WordPress.org

Ready to get started?Download WordPress

Forums

WordPress 2.8.4 Disaster with database charset (5 posts)

  1. kmlawson
    Member
    Posted 4 years ago #

    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:

    http://prisonnotebooks.com/?paged=3

    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!

  2. whooami
    Member
    Posted 4 years ago #

    is this inside your wp-config.php?

    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8');
  3. kmlawson
    Member
    Posted 4 years ago #

    yes, indeed, should it not be?

  4. whooami
    Member
    Posted 4 years ago #

    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');

  5. kmlawson
    Member
    Posted 4 years ago #

    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.

    Best,

    Konrad

Topic Closed

This topic has been closed to new replies.

About this Topic