WordPress 2.8.4 Disaster with database charset

  • kmlawson

    (@kmlawson)


    14 years, 7 months 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!

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

    (@whooami)

    14 years, 7 months ago

    is this inside your wp-config.php?

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

    (@kmlawson)

    14 years, 7 months ago

    yes, indeed, should it not be?

    whooami

    (@whooami)

    14 years, 7 months 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');

    Thread Starter kmlawson

    (@kmlawson)

    14 years, 7 months 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

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