{"id":3140,"date":"2014-10-20T19:17:02","date_gmt":"2014-10-20T11:17:02","guid":{"rendered":"https:\/\/sdeno.com\/?p=3140"},"modified":"2016-10-18T14:59:20","modified_gmt":"2016-10-18T06:59:20","slug":"%e8%a7%a3%e5%86%b3php%e8%be%93%e5%87%ba%e6%96%87%e6%9c%ac%e5%87%ba%e7%8e%b0%e4%b9%b1%e7%a0%81","status":"publish","type":"post","link":"https:\/\/sdeno.com\/?p=3140","title":{"rendered":"\u89e3\u51b3php\u8f93\u51fa\u6587\u672c\u51fa\u73b0\u4e71\u7801"},"content":{"rendered":"<p>\u89e3\u51b3php\u8f93\u51fa\u6587\u672c\u51fa\u73b0\u4e71\u7801\uff0c\u5728\u8f93\u51fa\u6587\u672c\u4e4b\u524d\u6dfb\u52a0\u4ee5\u4e0bphp\u4ee3\u7801\u5373\u53ef\uff1b<\/p>\n<pre>header('Content-Type: text\/html; charset=utf-8');<\/pre>\n<p>&nbsp;<\/p>\n<p>\u540c\u65f6\u8fd8\u8981\u4fdd\u8bc1\u521b\u5efa\u6570\u636e\u5e93\u7684\u65f6\u5019\u5b57\u7b26\u96c6\u4e5f\u662futf8\uff0cmysql\u9ed8\u8ba4\u521b\u5efa\u7684\u6570\u636e\u5e93\u90fd\u4e0d\u662futf8\uff0c\u6240\u4ee5\u6211\u4eec\u8981\u4fee\u6539\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6\uff0c\u4fdd\u8bc1\u9ed8\u8ba4\u521b\u5efa\u7684\u6570\u636e\u5e93\u9ed8\u8ba4\u90fd\u662futf8\u3002<\/p>\n<pre>SET character_set_client = utf8; \r\nSET character_set_connection = utf8; \r\nSET character_set_database = utf8; \r\nSET character_set_results = utf8; \r\nSET character_set_server = utf8;<\/pre>\n<p>\u9009\u4e2d\u6570\u636e\u5e93\u540e\u7528\u4ee5\u4e0a\u65b9\u6cd5\u4fee\u6539\u53ea\u662f\u6682\u65f6\u7684\uff0c\u53ea\u8981\u91cd\u542fmysql\u5c31\u4f1a\u8fd8\u539f\u5230\u539f\u6765\u7684\u5b57\u7b26\u96c6\u4e86\u3002\u6240\u4ee5\u6211\u4eec\u8981\u8fd9\u6837\uff1a<\/p>\n<p>1\uff0c\u6253\u5f00my.ini<\/p>\n<p>2\uff0c\u5206\u522b\u627e\u5230<\/p>\n<pre>[client]\r\n default-character-set=utf8  \/\/\u5982\u679c\u6ca1\u6709\u5c31\u989d\u5916\u6dfb\u52a0\u6b64\u4ee3\u7801\r\n[mysql]\r\n default-character-set=utf8  \/\/\u5982\u679c\u6ca1\u6709\u5c31\u989d\u5916\u6dfb\u52a0\u6b64\u4ee3\u7801\r\n[mysqld]\r\n character_set_server=utf8   \/\/\u5982\u679c\u6ca1\u6709\u5c31\u989d\u5916\u6dfb\u52a0\u6b64\u4ee3\u7801\r\n character-set-filesystem = utf8<\/pre>\n<p>3\uff0c\u91cd\u542fmysql<\/p>\n<p>\u73b0\u5728\u7528\u9ed8\u8ba4\u521b\u5efa\u6570\u636e\u5e93\u7684\u65b9\u6cd5\u521b\u5efa\u6570\u636e\u5e93<\/p>\n<pre>CREATE DATABASE `test2`;  \/\/\u521b\u5efa\u6570\u636e\u5e93\r\nSET NAMES 'utf8';  \/\/\u8bbe\u7f6e\u7f16\u7801\r\nuse test2  \/\/\u9009\u62e9\u6570\u636e\u5e93\r\nSHOW VARIABLES LIKE 'character%';  \/\/\u67e5\u770b\u6570\u636e\u5b57\u7b26\u96c6\r\nshow create database test2;  \/\/\u67e5\u770b\u6570\u636e\u5e93\u5b57\u7b26\u96c6<\/pre>\n<a href=\"https:\/\/sdeno.com\/wp-content\/uploads\/2014\/10\/mysql_utf8.jpg\"><figure class=\"mdx-lazyload-container\" style=\"max-width:376px\"><div style=\"padding-top:58.510638297872%\"><\/div><div class=\"mdx-img-loading-sp mdui-valign\"><div><div class=\"mdui-spinner\"><\/div><\/div><\/div><img width=\"376\" height=\"220\" class=\"alignnone size-full wp-image-5285 lazyload\" title=\"mysql_utf8\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-src=\"https:\/\/sdeno.com\/wp-content\/uploads\/2014\/10\/mysql_utf8.jpg\" alt=\"mysql_utf8\" data-srcset=\"https:\/\/sdeno.com\/wp-content\/uploads\/2014\/10\/mysql_utf8.jpg 376w, https:\/\/sdeno.com\/wp-content\/uploads\/2014\/10\/mysql_utf8-300x175.jpg 300w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\"><\/figure><\/a>\n<p><a href=\"http:\/\/blog.csdn.net\/qiyuexuelang\/article\/details\/9049985\" target=\"_blank\">http:\/\/blog.csdn.net\/qiyuexuelang\/article\/details\/9049985<\/a><\/p>\n<p><a href=\"http:\/\/bbs.csdn.net\/topics\/390901691?page=1\" target=\"_blank\">http:\/\/bbs.csdn.net\/topics\/390901691?page=1<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u89e3\u51b3php\u8f93\u51fa\u6587\u672c\u51fa\u73b0\u4e71\u7801\uff0c\u5728\u8f93\u51fa\u6587\u672c\u4e4b\u524d\u6dfb\u52a0\u4ee5\u4e0bphp\u4ee3\u7801\u5373\u53ef\uff1b header(&#8216;Content-Type: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-3140","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/3140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3140"}],"version-history":[{"count":0,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/3140\/revisions"}],"wp:attachment":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}