Well, now that I have a debit card again, I’ve registered a domain, and I’m in the process of migrating everything to wordpress. First I tried Andy Skelton’s excellent tool, but it didn’t handle the Chinese text in my blog too well.
WordPress database error: [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='] SELECT ID,post_date,post_title FROM wp_posts WHERE post_date='2005-11-30 23:43:00' AND post_title='[Movies] å�?'å·¦èµ°å�?'å�?³èµ° Turn Left Turn Right' LIMIT 1
It turns out that by default, MySql uses latin1_swedish_ci settings for collation_server as well as some other variables. Not too surprising I guess, since MySQL AB was founded by two Swedes and a Finn.
Fortunately, I’ve got everything working now. After my migration is done, my main blog will be at http://toshuo.com/, and have greatly improved categories support among other things. Here’s what my blog looks like with the default wordpress theme: