Encoding problem – writing in Chinese

  • xiaozhu

    (@xiaozhu)


    18 years, 7 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 ! 😉

Viewing 1 replies (of 1 total)
  • Thread Starter xiaozhu

    (@xiaozhu)

    18 years, 7 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 ??

Viewing 1 replies (of 1 total)

The topic ‘Encoding problem – writing in Chinese’ is closed to new replies.