Last weekend I spent one night to upgrade this blog from WordPress 1.5.1.3 to 2.2.1. Basically everything goes smoothly except the database character sets issue because there are some Chinese characters in my posts. I searched the web and tried many times and finally it works, though I still don’t know the details because I am really not good at MySQL things. What I did is:
- Run SQL query
show variables like '%character%';
to check the character sets of the database. If the
character_set_database
islatin1
, change it toutf8
byalter database mydb character set utf8;
where
mydb
is the name of the database. - Edit
wp-config.php
, change the linedefine('DB_CHARSET', 'utf8');
to
define('DB_CHARSET', '');
These two steps basically solve the Chinese display problem. (References: 1, 2 and 3)
The new version of WordPress is very good, especially the support of widgets and many other improvements from version 1.5.x. I also changed the theme to GlossyBlue 1.4 and modified a little.
0 Comments.