且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

UTF-8从MySQL损坏到SQLite

更新时间: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.