![]() I used navicat to dump the database and the file it generated was utf-8. In order to preserve non-ascii characters when transferring data from a mysql database encoded with latin1 to another mysql database:ġ) make sure that the target database is set with a default encoding of utf8ĪLTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Ģ) export the database encoded as utf-8. Here’s a checklist I saved for future-me last time I had to deal with it: ![]() Have you checked to make sure that the DB and the DB tables are all set to utf8_general_ci collation? I’ve seen it where the tables are utf8 but the database itself is latin1 and all hell breaks loose.
0 Comments
Leave a Reply. |