Support » Fixing WordPress » Problems with Mysql, Chinese and Danish characters

  • I have a Danish blog, where I often also write in Chinese.

    Until recently that was not a problem. However, I had to use a backup of the database, and now all the Chinese characters – in all three years of hundreds of articles – are converted into questionmarks.

    Plus, now I can’t publish Chinese characters either. I can write them, but once they are published, there’s just a line of ?????.

    None of the settings in WordPress, MySql or Mars Edit have changed.

    In Mars Edit the encoding is set to UTF-8 (which I need for special Danish characters æ, ø and å).

    In the WordPress dashboard it is also set to UTF-8.

    And in Php Admin MySql it is utf8_danish_ci.

    MySql is version 5.0.32 hosted by

    WordPress is 2.7.1.

    Config php haven’t changed either and is still:
    define(‘DB_CHARSET’, ‘utf8’);

    If I change it to:
    //define(‘DB_CHARSET’, ‘utf8’);

    … then the Chinese characters works fine, but the Danish ones are converted into a questionmarks on a black background.

    I use the backup plugin by Austin Matzko.

    So damn and blast. It all worked fine before. What to do? I really hope there’s help out there.

  • The topic ‘Problems with Mysql, Chinese and Danish characters’ is closed to new replies.