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 my 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 ?????.
As far as I can tell, 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.
I tried everything. In mysql I tried to upload the backup as utf8, latin and more or less all the rest.
I tried to change the mysql connection collation to latin, utf, whatever.
Did the same with charset.
Tried to use iconv to convert the backup online.
The settings in Wordpress positively did not change. But just to exclude it, I tried changing the wp-config.php.
The problem is not the Danish charecters, but the Chinese ones in all the posts. They are turned into ???? and no matter what I change whatever setting to I now can not publish them either.
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 my 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 ?????.
As far as I can tell, 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.
What to do? I really hope there’s help out there.
My guess is that one of either the WordPress or MySQL character encodings were different prior to restoring the database.
Try changing the various character encodings, such as changing WordPress's to utf8_danish_ci.
Also, there are also tools that let you convert one encoding to another, such as iconv. You could using such a tool on a copy of the database backup.
Hi,
Thanks for the fast reply.
I tried everything. In mysql I tried to upload the backup as utf8, latin and more or less all the rest.
I tried to change the mysql connection collation to latin, utf, whatever.
Did the same with charset.
Tried to use iconv to convert the backup online.
The settings in Wordpress positively did not change. But just to exclude it, I tried changing the wp-config.php.
The problem is not the Danish charecters, but the Chinese ones in all the posts. They are turned into ???? and no matter what I change whatever setting to I now can not publish them either.
RSS feed for this topic
Reply