BLOG STACK

Convert WordPress database charsets – UTF-8 encoding issues

If after moving your WordPress database around you find your site full of weird characters then your are likely suffering from double UTF-8 encoding problem. It is not a WordPress bug, but it is the way MySQL internals work.

To check if you are having this problem, you can try to comment out the line containing DB_CHARSET in your wp-config.php file. If your text is back to normal, then you are probably experiencing double UTF-8 encoding. WordPress Codex has an article covering this: http://codex.wordpress.org/Converting_Database_Character_Sets.

We released a script at our public github which puts all this together and solves the double UTF-8 encoding issue. It works by scanning all your tables and columns and generating a list of SQL statements which allow you to convert your content to UTF-8. To be run in the command line like this:

./wp-utf8ize.php > utf8ize.sql

Smart Managed WordPress Hosting

Presslabs provides high-performance hosting and business intelligence for the WordPress sites you care about.

Get Started