20 Aug 10 Display Chinese Characters in WordPress

By default, Chinese characters do not work in WordPress if you didn’t originally setup your WordPress to handle it. To display or compose Chinese in your blog, you can change the WordPress database Collations to utf8_unicode_ci for all tables. If you have phpMyAdmin, you can manually change them one by one. However, it will take long time to fix all of them. Here is an easy way to change all Collations using script.

1. Create a file as: alter_mysql_tables.php

2. Copy and paste the following lines to the file and modify it using your own database connection

Download File: [download id="1"]

3. Save the file and upload to your ftp.

4. Run the script in browser: http://www.yourdomain.com/alter_mysql_tables.php

5. That’s all!