WordPress.org

1. xiaozhu
   Member
   Posted 10 months ago #

   Hi there,

   I'm hoping to find suggestions for an on-going problem !

   Problem is two-folds :

   1) I recently moved from Blogger to Wordpress. All my posts in Chinese turned into "???????".

   I've heard of a similar encoding problem for those who upgraded their WordPress and followed the instructions, which was to delete :

   define('DB_CHARSET', 'utf8');
   define('DB_COLLATE', '');

   Didn't work for me... that said, I didn't upgrade in WP, I'm new here.

   2) If I type Chinese (coded in Unicode) in the admin. area of my blog in new posts, the characters show up correctly. But as soon as I publish the post, they turn into "????".

   A few things I checked :

   - My browser(s) do have Chinese fonts installed.
   - MySQL database is encoded in UTF-8 (I use Site5)

   So :

   -- Why do my old posts turned into "?????" and what could I do to correct that ?
   -- How can I write new posts in Chinese and have them showing up correctly ?

   I'll appreciate any help ! I spent 12 years learning Chinese so may as well use it ! ;)

2. xiaozhu
   Member
   Posted 10 months ago #

   Just an update...

   I re-tried to delete the :

   define('DB_CHARSET', 'utf8');
   define('DB_COLLATE', '');

   But it totally mess up my blog when I do that. I lose my widgets, my sidebars etc. AND the post in Chinese are still a bunch of "?????".

   I realized yesterday that despite the fact MySQL database is set as : MySQL charset: UTF-8 Unicode (utf8)

   ... if I open PHPmyadmin, all the tables are set as "latin1_swedish_ci" Huh ? How come ?

   Obviously, that's the root of my problem... But what do I do with that ??

Reply

You must log in to post.