• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

My Monkey Do

A Log of Coding Solutions

  • Home
  • Web Hosts
  • Tools
  • About

Other Languages showing as ??? in WordPress

May 29, 2012 by Webhead

Problem

I copy-pasted some Japanese text into the WordPress editor and it shows as ????.  On another server, pasting the same japanese text shows the japanese text on the page.  No plugins seem to be affecting this.  Something with the server or WordPress configuration must be affecting displaying the foreign characters.

Solution

The problem was caused by using the Fantastico automatic install from the cpanel.  When Fantastico installs wordpress all the fields in the database have a data type of “latin1_swedish_ci”.  Using this data type, characters like Japanese and Chinese are not supported.  You’ll need to change the data type of the fields to “utf8_general_ci”.  I changed post_title, post_content, and post_excerpt fields in wp_posts and it seems to be enough.  It depends how much you will have foreign characters though, you may have to change more fields.  More info can be found in the source below.

 

Source: http://wordpress.org/support/topic/special-characters-converted-to-question-marks-on-save
keywords: wordpress not saving japanese characters

Filed Under: Coding Tagged With: debug, wordpress

Primary Sidebar

Topics

apache apple block editor chrome cms css debug eCommerce embed firebug firefox git gmail goDaddy google hosting htaccess html html 5 IE crap image iPad iPhone javascript jquery linux localization mac os x ms sql mysql open source optimize php php 5.3 responsive rest api seo svg tinymce woocommerce wordpress wpengine xss yii youtube




Categories

  • Coding
  • Off the Shelf
  • Plugins
  • Random Thoughts
  • Server Stuff
  • Tools