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 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.
- The topic ‘Problems with Mysql, Chinese and Danish characters’ is closed to new replies.