更新时间:2023-11-27 13:19:46
感谢您的建议和评论.不幸的是,无论我选择哪种配置,都不需要.我最终只是简单地启动了两个PDO对象,并使用while
循环一次插入了一行. (我使用了mysqldump
的--no-data
选项来获取结构并手动对其进行修改.)
Well, thanks for the advice and comments. Unfortunately, no matter which configurations I chose, it wouldn't take. I ended up simply initiating two PDO objects and, using a while
loop, inserting one row at a time. (I used mysqldump
's --no-data
option to get the structure and modified that by hand.)
在我的256MB CentOS盒子上插入了大约10,000行,相当于9.4MB的数据,大约花了10分钟. (因此,如果您使用的是共享环境,请注意最长的执行时间.)SQLite数据库现在返回正确的Unicode数据.
It took about 10 minutes to insert ~10,000 rows equal to 9.4MB of data on my 256MB CentOS box. (So if you're on a shared environment, be wary of the maximum execution time.) The SQLite database now returns proper Unicode data.
自我说明:编写变通办法比找到推荐的解决方案容易.
Note to self: It's easier to code a work-around than finding the recommended solution.