Support » Fixing WordPress » WordPress 2.8.4 Disaster with database charset

  • I just upgraded the blog from a recent version to 2.8.4.

    The blog, which has Japanese and English text, became COMPLETELY mangled as a result of the upgrade as is seen here:

    After searching on these forums, I used PhpMyAdmin to convert all the tables from latin1_swedish to ut8_unicode_ci.

    After the conversion, nothing has changed…I still have a weblog filled with mangled Japanese text, despite the fact that both the MySql tables and the wordpress installation are ostensibly configured for Unicode.

    Any thoughts on what I can possibly do now to get the Japanese back into readable form? Restoring the Mysql database from before the upgrade and upgrading it again did not work wither.

    I hope that someone will have suggestions for me!

Viewing 4 replies - 1 through 4 (of 4 total)
  • whooami



    is this inside your wp-config.php?

    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8');

    yes, indeed, should it not be?




    well, you probably should have started by commenting that out, or changing it, yeah. comment it out now, and see if it helps?

    //define('DB_CHARSET', 'utf8');

    Thanks so much. That works, but I’m very confused as to why that works. That is still in the sample wp-config file which comes with the wordpress installation and utf8 is the character set one would want too right?

    Anyways, it worked, but would love to know why.



Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress 2.8.4 Disaster with database charset’ is closed to new replies.