{"id":327,"date":"2016-05-19T08:37:38","date_gmt":"2016-05-19T08:37:38","guid":{"rendered":"http:\/\/angelwings.net\/blog\/?p=327"},"modified":"2016-05-19T08:37:38","modified_gmt":"2016-05-19T08:37:38","slug":"phpmyadmin-mysql-export-simplified-chinese-utf-csv-gibberish-text-issue","status":"publish","type":"post","link":"https:\/\/angelwings.net\/blog\/phpmyadmin-mysql-export-simplified-chinese-utf-csv-gibberish-text-issue\/","title":{"rendered":"phpmyadmin: mysql export Simplified Chinese utf csv gibberish text issue"},"content":{"rendered":"<p>The database collation is utf8_unicode_ci but can&#8217;t guarantee the Chinese text encoding was 100% correct during data entry (may have mixed with Traditional Chinese?)<\/p>\n<p>When we use the usual route in phpmyadmin to export the data to .csv, the generated .csv file doesn&#8217;t show the Simplified Chinese text properly. Same issue when exporting to Microsoft .csv<\/p>\n<p>Manual workaround: Export the data to .csv but select &#8220;View output as text&#8221;. This somehow generates the data with the Simplified Chinese text correctly.<\/p>\n<p>Select all, copy and paste to your Microsoft Excel and&#8230; problem solved.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The database collation is utf8_unicode_ci but can&#8217;t guarantee the Chinese text encoding was 100% correct during data entry (may have mixed with Traditional Chinese?) When we use the usual route in phpmyadmin to export the data to .csv, the generated .csv file doesn&#8217;t show the Simplified Chinese text properly. Same issue when exporting to Microsoft [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,28],"tags":[48,54,61,89,98],"class_list":["post-327","post","type-post","status-publish","format-standard","hentry","category-database","category-troubleshoot","tag-chinese","tag-csv","tag-encoding","tag-mysql","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts\/327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":0,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts\/327\/revisions"}],"wp:attachment":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/categories?post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/tags?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}