Saturday, April 26, 2008

Importing UTF-8 Datasets in MySQL

Before importing a UTF-8 dataset, be sure to change the default MySQL database collation to utf8_unicode_ci.

Note: If the tables and structures are in the utf8 collation but the database is on a Latin collation, the import will not be successful.

The database, tables and structures need to be all UTF8 enabled.

No comments: