[SOLVED] Cyrillic characters become '???' (question marks)
Weird. A comment in Russian
|
it shows all ? marks on both links
|
Quote:
But trust me, at the time I was writing the OP, the situation was exactly as I described: Russian characters via the 1st link, ??? via the 2nd link. Don't know what could happen since then... |
are the comments being entered on the blog or are they coming from facebook and being inserted via some plugin?
|
They are imported from Facebook (from http://goo.gl/cp0KD ) automatically via add-link-to-facebook plugin.
|
There is probably a character set conversion issue going on. I just pasted that comment into a comment on my local site and it shows fine.
Take a look in teh database and see what the comment looks like there. Also what is the character set being used in the db? |
Yes, I tracked down the root cause on my end: some WP’s database tables are using the legacy (pre-WP 2.2) "CHARACTER SET latin1" instead of the new "CHARACTER SET utf8". Now I am scratching my head: how (with least efforts) to convert the database character sets from latin1 to utf8? There are too many choices...
The WP codex article "Converting Database Character Sets" is dated 2010 and describes a very manual and a very involved method; The "UTF-8 Database Converter" plugin is dated 2010 and is no longer being maintained by the author; it uses behind the scene the SQL statements: PHP Code:
PHP Code:
|
what ever you do, start with a database backup.
actually you could try 1) do a database export, 2) edit the export and change the language. 3) delete the database 4) import the new one. do it to a test database first |
Yes, that's exactly what I did, and it worked. It's the same as method proposed in Alex King's blog about latin1 to utf8 conversion. Thanks!
|
All times are GMT -6. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.