{"id":804,"date":"2012-05-29T16:03:12","date_gmt":"2012-05-30T02:03:12","guid":{"rendered":"http:\/\/mymonkeydo.com\/?p=804"},"modified":"2012-05-29T16:03:12","modified_gmt":"2012-05-30T02:03:12","slug":"other-languages-showing-as-in-wordpress","status":"publish","type":"post","link":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/","title":{"rendered":"Other Languages showing as ??? in WordPress"},"content":{"rendered":"<h2>Problem<\/h2>\n<p>I copy-pasted some Japanese text into the WordPress editor and it shows as ????. \u00a0On another server, pasting the same japanese text shows the japanese text on the page. \u00a0No plugins seem to be affecting this. \u00a0Something with the server or WordPress configuration must be affecting displaying the foreign characters.<\/p>\n<h2>Solution<\/h2>\n<p>The problem was caused by using the Fantastico automatic install from the cpanel. \u00a0When Fantastico installs wordpress all the fields in the database have a data type of &#8220;latin1_swedish_ci&#8221;. \u00a0Using this data type, characters like Japanese and Chinese are not supported. \u00a0You&#8217;ll need to change the data type of the fields to &#8220;utf8_general_ci&#8221;. \u00a0I changed post_title, post_content, and post_excerpt fields in wp_posts and it seems to be enough. \u00a0It depends how much you will have foreign characters though, you may have to change more fields. \u00a0More info can be found in the source below.<\/p>\n<p>&nbsp;<\/p>\n<p>Source: <a href=\"http:\/\/wordpress.org\/support\/topic\/special-characters-converted-to-question-marks-on-save\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/wordpress.org\/support\/topic\/special-characters-converted-to-question-marks-on-save<\/a><br \/>\nkeywords: wordpress not saving japanese characters<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[2],"tags":[18,64],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Other Languages showing as ??? in Wordpress - My Monkey Do<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Other Languages showing as ??? in Wordpress - My Monkey Do\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"My Monkey Do\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-30T02:03:12+00:00\" \/>\n<meta name=\"author\" content=\"Webhead\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Webhead\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/\",\"url\":\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/\",\"name\":\"Other Languages showing as ??? in Wordpress - My Monkey Do\",\"isPartOf\":{\"@id\":\"https:\/\/mymonkeydo.com\/#website\"},\"datePublished\":\"2012-05-30T02:03:12+00:00\",\"dateModified\":\"2012-05-30T02:03:12+00:00\",\"author\":{\"@id\":\"https:\/\/mymonkeydo.com\/#\/schema\/person\/b16fc650a8c182faaac896bab099b829\"},\"breadcrumb\":{\"@id\":\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mymonkeydo.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Other Languages showing as ??? in WordPress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mymonkeydo.com\/#website\",\"url\":\"https:\/\/mymonkeydo.com\/\",\"name\":\"My Monkey Do\",\"description\":\"A Log of Coding Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mymonkeydo.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/mymonkeydo.com\/#\/schema\/person\/b16fc650a8c182faaac896bab099b829\",\"name\":\"Webhead\",\"url\":\"https:\/\/mymonkeydo.com\/author\/corey\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Other Languages showing as ??? in Wordpress - My Monkey Do","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"Other Languages showing as ??? in Wordpress - My Monkey Do","og_url":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/","og_site_name":"My Monkey Do","article_published_time":"2012-05-30T02:03:12+00:00","author":"Webhead","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Webhead","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/","url":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/","name":"Other Languages showing as ??? in Wordpress - My Monkey Do","isPartOf":{"@id":"https:\/\/mymonkeydo.com\/#website"},"datePublished":"2012-05-30T02:03:12+00:00","dateModified":"2012-05-30T02:03:12+00:00","author":{"@id":"https:\/\/mymonkeydo.com\/#\/schema\/person\/b16fc650a8c182faaac896bab099b829"},"breadcrumb":{"@id":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mymonkeydo.com\/other-languages-showing-as-in-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mymonkeydo.com\/"},{"@type":"ListItem","position":2,"name":"Other Languages showing as ??? in WordPress"}]},{"@type":"WebSite","@id":"https:\/\/mymonkeydo.com\/#website","url":"https:\/\/mymonkeydo.com\/","name":"My Monkey Do","description":"A Log of Coding Solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mymonkeydo.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/mymonkeydo.com\/#\/schema\/person\/b16fc650a8c182faaac896bab099b829","name":"Webhead","url":"https:\/\/mymonkeydo.com\/author\/corey\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/posts\/804"}],"collection":[{"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/comments?post=804"}],"version-history":[{"count":0,"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/posts\/804\/revisions"}],"wp:attachment":[{"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/media?parent=804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/categories?post=804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mymonkeydo.com\/wp-json\/wp\/v2\/tags?post=804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}