{"id":63,"date":"2005-08-27T09:47:49","date_gmt":"2005-08-27T01:47:49","guid":{"rendered":"http:\/\/192.168.0.1\/blog_4.4.2\/?p=63"},"modified":"2005-09-05T23:44:08","modified_gmt":"2005-09-05T15:44:08","slug":"mysql-sxyad","status":"publish","type":"post","link":"https:\/\/blog.worren.net\/?p=63","title":{"rendered":"MySQL \u7684\u7de8\u78bc\u554f\u984c"},"content":{"rendered":"<div class='drop-case'> <p> default code&#8230; <br \/> \ndb       : utf8 <br \/> \ntable  : utf8 <br \/> \nfield   : utf8<\/div>\n <p> html default charset=utf8\n <p> \u82e5\u5728\u6b04\u4f4d\u4e2d\u52a0\u5165 \\&#8221;\u6e90\\&#8221; &#8230;. \u6703\u51fa\u73fe\u5982\u4e0b\u5217\u72c0\u6cc1   &#8230;.\n <p>  <!--more--> \n <p> Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation \\&#8217;=\\&#8217; <br \/> \n\u90fd\u5df2\u7d93\u8a2d\u6210 utf8 \u4e86, \u54ea\u3126\u4f86\u7684 latin1 ? <br \/> \nm ~ .. \u7528 phpmyadmin \u770b mysql \u7cfb\u7d71\u8b8a\u6578 or \u5230 mysql client \u4e0b\u770b <br \/> \n\\&#8217;%char%\\&#8217; &#8230;. \u5c31\u53ef\u4ee5\u770b\u5230\u4e00\u4e9b\u53c3\u6578\u503c\u4ecd\u662f latin\n <p> \u89e3\u6c7a\u65b9\u6cd5 : <br \/> \n\u628a db , table , field \u7684\u7de8\u78bc\u6539\u6210\u9810\u8a2d\u7684 latin1_swedish_ci <br \/> \n\u800chtml \u5c31\u7dad\u6301 utf8;\n <p> \u5370\u8c61\u4e2d~~~~~&#8230;.utf8 \u5c31\u662f\u628a1~3\u500b ascii code\u7d44\u5408\u62101\u500b\u5b57\u5143, <br \/> \n\u90a3 1~3 \u500b ascii code \u5b58\u5728 latin1 \u88e1\u61c9\u8a72\u662f ok \u7684\u5427! &#8230;.. <br \/> \n\u7de8\u78bc\u7684\u5de5\u4f5c\u5c31\u4ea4\u7d66 browser\u5427!\n <p> but \u6211\u89ba\u5f97\u597d\u5947\u7684\u662f, html \u8a2d\u6210 utf8 , MySQL \u8a2d\u6210 utf8 &#8230; <br \/> \n\u90a3MySQL \u6536\u5230\u4e86 1~3\u500b Ascii Code \u8b8a\u70ba1\u500b\u5b57\u5143\u7684\u8cc7\u6599, \u5b83\u5c07\u600e\u6a23\u6536\u9304\u5230 db \u88e1? <br \/> \n\u8a72\u4e0d\u6703\u628a4\u500bAscii Code \u5206\u5225\u518d\u7de8\u4e00\u6b21\u5427 &#8230;.. ~\\&#8221;~\n","protected":false},"excerpt":{"rendered":" <p> default code&#8230; db : utf8 table : utf8 field : utf8 html default charset=utf8 \u82e5\u5728\u6b04\u4f4d\u4e2d\u52a0\u5165 \\&#8221;\u6e90\\&#8221; &#8230;. \u6703\u51fa\u73fe\u5982\u4e0b\u5217\u72c0\u6cc1 &#8230;. <\/p> \n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts\/63"}],"collection":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=63"}],"version-history":[{"count":0,"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}