WordPress.org

Forums

How to Maintain Multi-byte Characters in WP 2.7? (10 posts)

  1. misty9
    Member
    Posted 6 years ago #

    The multi-byte characters (Japanse, Korean and etc.) displayed in WP 2.2 pages/post perfectly, but they don't seem to work in WP 2.7 for me. Are there special steps required for displaying multi-byte characters in the pages/posts?

    Thanks.

  2. figaro
    Member
    Posted 6 years ago #

    Just a shot in the dark here, but is your 2.7 database and all the tables set to utf8 encoding?

  3. misty9
    Member
    Posted 6 years ago #

    Thanks for your reply, figaro.

    The MySQL charset: UTF-8 Unicode (utf8), I didn't do any tweaking either when using WP 2.2.

  4. figaro
    Member
    Posted 6 years ago #

    Just to be sure, are both your database and tables showing utf8...see the screen shot at the link below. Also, make sure your config.php file is set to utf8.

    If you installed with an auto-installer, they are notorious for creating the db tables as latin1, so even if you didn't do any tweaking before, it's still good to check. Again, just a shot in the dark here...this may not be the problem, but it's worth checking.

    http://educhalk.org/blog5/

  5. misty9
    Member
    Posted 6 years ago #

    You are right.

    The collation for all tables are set to "latin1_swedish_ci" except for wp_terms, wp_term_relationships and wp_taxonomy with "utf8_general_ci".

    I am in the process of changing all fields of each table applicable from "latin..." to utf8_general_ci, is there a way to update a table just once instead of updating one field at a time?

    Thanks again.

  6. figaro
    Member
    Posted 6 years ago #

    The quickest way is to dump the db, do a search and replace, then drop the tables and import your corrected sql file. However, just be aware, regardless of how you do this, it will not change the encoding of existing data in the database...that's a far more complex process.

  7. misty9
    Member
    Posted 6 years ago #

    It's working now after I had manually replaced "latin..." with utf8_general_ci" for all fields of all tables. Thank you very much.

    However the Collation columns of the database for the tables still show "latin_...", but the fields of the tables reflect the latest changes.

  8. figaro
    Member
    Posted 6 years ago #

    When you are viewing your complete list of tables on the right in phpMyAdmin, click on the "Structure" icon under "Action"...should be the second icon. Then click "Operations" at the top and you should be able to change the table encoding there.

  9. misty9
    Member
    Posted 6 years ago #

    Hooray! All fixed now. Thanks a million, Figaro.

  10. figaro
    Member
    Posted 6 years ago #

    You're welcome...glad you got it working.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.