{"id":92,"date":"2012-04-27T17:31:47","date_gmt":"2012-04-27T09:31:47","guid":{"rendered":"http:\/\/fishinbox.tk\/?p=92"},"modified":"2012-04-27T17:31:47","modified_gmt":"2012-04-27T09:31:47","slug":"sql-data-character-set-configuration","status":"publish","type":"post","link":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/","title":{"rendered":"SQL data character set configuration"},"content":{"rendered":"<p>Days ago I posted an article containing\u00a0Greek characters which didn&#8217;t go as expected, but I failed to look further in this issue. I totally didn&#8217;t realize that it has some thing to do with my database character set configuration.<\/p>\n<p>But today, a friend post a comment on my page and it&#8217;s so sad that the comment became multiple question marks &#8220;????&#8230;&#8221;. And this is when I realized that there was something wrong and by Googling I gained the knowledge that it may has something to do with my American free web space provider, who provided SQL database but in latin character set as default, which leads to the whole following things.<\/p>\n<p>It&#8217;s tough to change the character set field by filed but finally I made it, and this web site is supposed to be compatible with all UTF-8 characters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Days ago I posted an article containing\u00a0Greek characters which didn&#8217;t go as expected, but I failed to look further in this issue. I totally didn&#8217;t realize that it has some thing to do with my database character set configuration. But today, a friend post a comment on my page and it&#8217;s so sad that the &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL data character set configuration&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[26,37,47,48,49],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-website","tag-character-set","tag-latin","tag-sql-database","tag-utf-8","tag-utf8"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"SQL data character set configuration\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Hamilleton\"\/>\n\t<meta name=\"google-site-verification\" content=\"MU5z5UygVAc-wvTryHZh_Pyu9TTGhb65shw7AGmXpgE\" \/>\n\t<meta name=\"keywords\" content=\"sql database,character set,latin,utf8,utf-8,character set,latin,sql database,utf-8,utf8,web site\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ZigZagRoad | Thoughts in Life and Research on Work\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQL data character set configuration | ZigZagRoad\" \/>\n\t\t<meta property=\"og:description\" content=\"SQL data character set configuration\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-04-27T09:31:47+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2012-04-27T09:31:47+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL data character set configuration | ZigZagRoad\" \/>\n\t\t<meta name=\"twitter:description\" content=\"SQL data character set configuration\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#article\",\"name\":\"SQL data character set configuration | ZigZagRoad\",\"headline\":\"SQL data character set configuration\",\"author\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/author\\\/hamilleton\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/#person\"},\"datePublished\":\"2012-04-27T17:31:47+08:00\",\"dateModified\":\"2012-04-27T17:31:47+08:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#webpage\"},\"articleSection\":\"Web Site, character set, latin, SQL database, utf-8, utf8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/#listItem\",\"name\":\"Study, Research and Work\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/#listItem\",\"position\":2,\"name\":\"Study, Research and Work\",\"item\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/website\\\/#listItem\",\"name\":\"Web Site\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/website\\\/#listItem\",\"position\":3,\"name\":\"Web Site\",\"item\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/website\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#listItem\",\"name\":\"SQL data character set configuration\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/#listItem\",\"name\":\"Study, Research and Work\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#listItem\",\"position\":4,\"name\":\"SQL data character set configuration\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/category\\\/study-research-work\\\/website\\\/#listItem\",\"name\":\"Web Site\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/#person\",\"name\":\"Hamilleton\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/author\\\/hamilleton\\\/#author\",\"url\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/author\\\/hamilleton\\\/\",\"name\":\"Hamilleton\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#webpage\",\"url\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/\",\"name\":\"SQL data character set configuration | ZigZagRoad\",\"description\":\"SQL data character set configuration\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/2012\\\/04\\\/sql-data-character-set-configuration\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/author\\\/hamilleton\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/author\\\/hamilleton\\\/#author\"},\"datePublished\":\"2012-04-27T17:31:47+08:00\",\"dateModified\":\"2012-04-27T17:31:47+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/\",\"name\":\"ZigZagRoad\",\"description\":\"Thoughts in Life and Research on Work\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/zhuangzr.me\\\/wordpress\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQL data character set configuration | ZigZagRoad","description":"SQL data character set configuration","canonical_url":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/","robots":"max-image-preview:large","keywords":"sql database,character set,latin,utf8,utf-8,character set,latin,sql database,utf-8,utf8,web site","webmasterTools":{"google-site-verification":"MU5z5UygVAc-wvTryHZh_Pyu9TTGhb65shw7AGmXpgE","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#article","name":"SQL data character set configuration | ZigZagRoad","headline":"SQL data character set configuration","author":{"@id":"https:\/\/zhuangzr.me\/wordpress\/author\/hamilleton\/#author"},"publisher":{"@id":"https:\/\/zhuangzr.me\/wordpress\/#person"},"datePublished":"2012-04-27T17:31:47+08:00","dateModified":"2012-04-27T17:31:47+08:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#webpage"},"isPartOf":{"@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#webpage"},"articleSection":"Web Site, character set, latin, SQL database, utf-8, utf8"},{"@type":"BreadcrumbList","@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress#listItem","position":1,"name":"Home","item":"https:\/\/zhuangzr.me\/wordpress","nextItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/#listItem","name":"Study, Research and Work"}},{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/#listItem","position":2,"name":"Study, Research and Work","item":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/","nextItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/#listItem","name":"Web Site"},"previousItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/#listItem","position":3,"name":"Web Site","item":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/","nextItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#listItem","name":"SQL data character set configuration"},"previousItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/#listItem","name":"Study, Research and Work"}},{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#listItem","position":4,"name":"SQL data character set configuration","previousItem":{"@type":"ListItem","@id":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/#listItem","name":"Web Site"}}]},{"@type":"Person","@id":"https:\/\/zhuangzr.me\/wordpress\/#person","name":"Hamilleton"},{"@type":"Person","@id":"https:\/\/zhuangzr.me\/wordpress\/author\/hamilleton\/#author","url":"https:\/\/zhuangzr.me\/wordpress\/author\/hamilleton\/","name":"Hamilleton"},{"@type":"WebPage","@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#webpage","url":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/","name":"SQL data character set configuration | ZigZagRoad","description":"SQL data character set configuration","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/zhuangzr.me\/wordpress\/#website"},"breadcrumb":{"@id":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/#breadcrumblist"},"author":{"@id":"https:\/\/zhuangzr.me\/wordpress\/author\/hamilleton\/#author"},"creator":{"@id":"https:\/\/zhuangzr.me\/wordpress\/author\/hamilleton\/#author"},"datePublished":"2012-04-27T17:31:47+08:00","dateModified":"2012-04-27T17:31:47+08:00"},{"@type":"WebSite","@id":"https:\/\/zhuangzr.me\/wordpress\/#website","url":"https:\/\/zhuangzr.me\/wordpress\/","name":"ZigZagRoad","description":"Thoughts in Life and Research on Work","inLanguage":"en-US","publisher":{"@id":"https:\/\/zhuangzr.me\/wordpress\/#person"}}]},"og:locale":"en_US","og:site_name":"ZigZagRoad | Thoughts in Life and Research on Work","og:type":"article","og:title":"SQL data character set configuration | ZigZagRoad","og:description":"SQL data character set configuration","og:url":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/","og:image":"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg","og:image:secure_url":"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg","article:published_time":"2012-04-27T09:31:47+00:00","article:modified_time":"2012-04-27T09:31:47+00:00","twitter:card":"summary","twitter:title":"SQL data character set configuration | ZigZagRoad","twitter:description":"SQL data character set configuration","twitter:image":"https:\/\/ziruizhuang.github.io\/assets\/img\/prof_pic.jpg"},"aioseo_meta_data":{"post_id":"92","title":"SQL data character set configuration | #site_title","description":"SQL data character set configuration","keywords":[{"label":"SQL database,character set,latin,utf8,utf-8","value":"SQL database,character set,latin,utf8,utf-8"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-24 07:00:03","updated":"2025-07-03 08:46:34","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/zhuangzr.me\/wordpress\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/\" title=\"Study, Research and Work\">Study, Research and Work<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/\" title=\"Web Site\">Web Site<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQL data character set configuration\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/zhuangzr.me\/wordpress"},{"label":"Study, Research and Work","link":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/"},{"label":"Web Site","link":"https:\/\/zhuangzr.me\/wordpress\/category\/study-research-work\/website\/"},{"label":"SQL data character set configuration","link":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/sql-data-character-set-configuration\/"}],"_links":{"self":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":0,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}