Problems with Mysql, Chinese and Danish characters (1 post)

  1. fersken
    Posted 7 years ago #

    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 One.com.

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic