WordPress in Japanese and English

Problem: Can not write in Japanese and English using WordPress. Characters display as ? ?? ???

I was trying to figure out how to write in Japanese on my WordPress blog. All Japanese characters were coming up as question marks, appearing like “????? ? ?? ???” instead of characters. I searched for a solution to this and found a few plugins that did a ton of unnecessary things, and some didn’t work. I tried out Gengo but I didn’t like it very much. However if you’re reading this for a solution on how to write Japanese and English or translate your page it might work well for you! Here’s the link to Gengo.

Wordpress

If you’re running WordPress 2.2 or higher, then the Collation should be set correctly. Here’s a link to their documentation, and here’s an excerpt.

As of WordPress Version 2.2, DB_COLLATE was made available to allow designation of the database collation (i.e. the sort order of the character set). In most cases, this value should be left blank (null) so the database collation will be automatically assigned by MySQL based on the database character set (i.e. DB_CHARSET). Set DB_COLLATE to one of the UTF-8 values defined in Unicode character sets (utf8 section) (see dev.mysql.com) for most Western European languages.

Now if you are running an older version, or you upgraded from an older version, or for some reason things aren’t working out I’ll post my solution below.

Solution: EASY! First backup your database in case you mess this up. Next use phpMyAdmin and choose a table (wp_posts) and then select the field you want to edit or show Japanese. Let’s say you want your posts to display Japanese, you would edit “post_content” and change the Collation to utf8_unicode_ci. It might have latin1_swedish_ci as the default. You can do this to any field. Posts, comments, categories, etc. Now you can Japanese it up! You can write in Chinese, Korean, whatever character set you’re using most likely. Niiiiiiiiiiiiiice.

If this doesn’t make sense to you then I’ll give you a step by step break down.

  1. Back up your database. Not sure how? Check out this wordpress database plugin called WP-DBManager.
  2. Log into your phpMyAdmin
  3. Choose your database on the left
  4. Under your database on the left, click on wp_comments
  5. On the right you’ll see Field, Type, Collation, Attributes, etc.
  6. For the Fields that have Collation set as something other than utf8_unicode_ci you should tick the check box.
  7. After you ticked all check boxes in that table, click the pencil icon at the bottom. When you mouse over it there should be a tool tip that says “change”. When you click this you can edit those fields.
  8. Using the drop down box on each field you can now change the Collation from whatever it is (example latin1_swedish_ci) to the bottom selection in the drop down box which is utf8_unicode_ci.
  9. Hit Save
  10. Now click on the next table on the left hand side which should be called wp_links.
  11. Repeat these steps for each table.

I also found this solution from the wordpress support area.
2.2 update Japanese character problem (“?”)

WordPress, now in 日本語言語!

Latest Comments
  1. Tori December 10, 2007
  2. Steve December 19, 2007
  3. Minh T. Le February 5, 2008
  4. Steve February 17, 2008
  5. Steve March 7, 2008
  6. jay May 2, 2008
  7. antiquarian books December 11, 2008
  8. bertrand December 12, 2008
  9. nipponon December 25, 2008
  10. JL January 14, 2009
  11. zurui January 15, 2009
  12. Kanjidude April 18, 2009
  13. Steve April 21, 2009
  14. Faye September 18, 2009
  15. Cupcaketoons October 19, 2009
  16. Juno January 9, 2010
  17. Juno January 10, 2010
  18. Jenny April 9, 2010
  19. doggitydogs September 4, 2010
    • Steve September 5, 2010
  20. Nicolas Cueto October 14, 2010
  21. animateholic November 12, 2011
  22. kichinosuke November 11, 2012
    • Steve November 13, 2012

Leave a Reply