{"id":97,"date":"2007-05-19T23:39:49","date_gmt":"2007-05-19T15:39:49","guid":{"rendered":"http:\/\/www.hmqq.net\/index.php\/2007\/05\/19\/wp22-mysql-utf8\/"},"modified":"2008-10-29T23:35:54","modified_gmt":"2008-10-29T15:35:54","slug":"wp22-mysql-utf8","status":"publish","type":"post","link":"https:\/\/minqiao.me\/?p=97","title":{"rendered":"\u5347\u7ea7\u5230WordPress 2.2\uff0c\u89e3\u51b3\u4e71\u7801\u7684\u95ee\u9898"},"content":{"rendered":"<p>WordPress 2.2\u53d1\u5e03\u4e86\uff0c\u4e8e\u662f\u5c31\u52a8\u624b\u628a\u8fd9\u4e2aBlog\u5347\u7ea7\u4e86\u4e00\u4e0b\u3002\u4f46\u662f\u5347\u7ea7\u5b8c\u5c31\u90c1\u95f7\u4e86\uff0c\u4e2d\u6587\u90fd\u662f\u4e71\u7801\u3002\u8d76\u7d27Google\u641c\u7d22\u201cMySQL WordPress2.2 \u4e71\u7801 utf8\u201d\u8fd9\u51e0\u4e2a\u5173\u952e\u5b57\uff0c\u627e\u5230\u4e00\u4e2a\u4e34\u65f6\u89e3\u51b3\u529e\u6cd5\uff0c\u5c31\u662f\u628awp-config.php\u91cc\u9762\u7684\u4e24\u884c\u4ee3\u7801\u6ce8\u91ca\u6389\u3002<code><br \/>\n\/\/define('DB_CHARSET', 'utf8');<br \/>\n\/\/define('DB_COLLATE', '');<\/code><\/p>\n<p><code><\/code><br \/>\n\u4f46\u662f\u8fd9\u6837\u8fd8\u662f\u6cbb\u6807\u4e0d\u6cbb\u672c\uff0c\u53c8\u770b\u4e86\u5f88\u591a\u5e16\u5b50\uff0c\u7ec8\u4e8e\u628a\u95ee\u9898\u89e3\u51b3\u3002<code><br \/>\nmysqldump --compatible=mysql40 wordpress -p &gt;\/tmp\/wp-40.sql<br \/>\nmysql&gt;drop database wordpress;<br \/>\nmysql&gt;create database wordpress default character set utf8 collate utf8_general_ci;<br \/>\nmysql -p wordpress --default-character-set=utf8 &lt; \/tmp\/wp-40.sql<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress 2.2\u53d1\u5e03\u4e86\uff0c\u4e8e\u662f\u5c31\u52a8\u624b\u628a\u8fd9\u4e2aBlog\u5347\u7ea7\u4e86\u4e00\u4e0b\u3002\u4f46\u662f\u5347\u7ea7\u5b8c\u5c31\u90c1\u95f7\u4e86\uff0c\u4e2d\u6587\u90fd\u662f\u4e71\u7801\u3002\u8d76\u7d27Google\u641c\u7d22\u201cMySQL WordPress2.2 \u4e71\u7801 utf8\u201d\u8fd9\u51e0\u4e2a\u5173\u952e\u5b57\uff0c\u627e\u5230\u4e00\u4e2a\u4e34\u65f6\u89e3\u51b3\u529e\u6cd5\uff0c\u5c31\u662f\u628awp-config.php\u91cc\u9762\u7684\u4e24\u884c\u4ee3\u7801\u6ce8\u91ca\u6389\u3002 \/\/define(&#8216;DB_CHARSET&#8217;, &#8216;utf8&#8217;); \/\/define(&#8216;DB_COLLATE&#8217;, &#8221;); \u4f46\u662f\u8fd9\u6837\u8fd8\u662f\u6cbb\u6807\u4e0d\u6cbb\u672c\uff0c\u53c8\u770b\u4e86\u5f88\u591a\u5e16\u5b50\uff0c\u7ec8\u4e8e\u628a\u95ee\u9898\u89e3\u51b3\u3002 mysqldump &#8211;compatible=mysql40 wordpress -p &gt;\/tmp\/wp-40.sql mysql&gt;drop database wordpress; mysql&gt;create database wordpress default character set utf8 collate utf8_general_ci; mysql -p wordpress &#8211;default-character-set=utf8 &lt; \/tmp\/wp-40.sql<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[24,25],"class_list":["post-97","post","type-post","status-publish","format-standard","hentry","category-tech","tag-mysql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/minqiao.me\/index.php?rest_route=\/wp\/v2\/posts\/97","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/minqiao.me\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minqiao.me\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minqiao.me\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/minqiao.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=97"}],"version-history":[{"count":0,"href":"https:\/\/minqiao.me\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions"}],"wp:attachment":[{"href":"https:\/\/minqiao.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minqiao.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minqiao.me\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}