{"id":287,"date":"2022-06-10T11:40:36","date_gmt":"2022-06-10T03:40:36","guid":{"rendered":"https:\/\/frogvps.com\/?p=287"},"modified":"2022-06-10T13:40:51","modified_gmt":"2022-06-10T05:40:51","slug":"mysql%e6%80%8e%e4%b9%88%e8%ae%be%e7%bd%ae%e5%ad%97%e7%ac%a6%e9%9b%86%e5%92%8c%e6%8e%92%e5%ba%8f","status":"publish","type":"post","link":"https:\/\/frogvps.com\/?p=287","title":{"rendered":"MYSQL\u600e\u4e48\u8bbe\u7f6e\u5b57\u7b26\u96c6\u548c\u6392\u5e8f"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">MSQL\u5b57\u7b26\u96c6\u548c\u6392\u5e8f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e9\u671fMySQL\u7248\u672c\u9ed8\u8ba4\u4e3alatin1\uff0c\u4eceMySQL8.0\u5f00\u59cb\u9ed8\u8ba4\u5b57\u7b26\u96c6\u5df2\u7ecf\u4e3a utf8mb4\u3002\u5efa\u8bae\u9ed8\u8ba4\u5b57\u7b26\u96c6\u7edf\u4e00\u6539\u6210utf8mb4\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770b\u6240\u6709\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW CHARACTER SET;\nSHOW CHARSET;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW VARIABLES LIKE \"character%\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770b\u6240\u6709\u6392\u5e8f\u89c4\u5219\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW COLLATION;\n#\u9ed8\u8ba4\u7684utf8mb4_0900_ai_ci\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0c\u5982\u9700\u8981\u533a\u5206\u5927\u5c0f\u5199\uff0c\u53ef\u6539\u4e3autf8mb4_bin<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u6392\u5e8f\u89c4\u5219\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW VARIABLES LIKE \"collation%\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bbe\u7f6e\u670d\u52a1\u5668\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]\ncharacter-set-server=utf8mb4<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysql]\ndefault-character-set=utf8mb4<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MSQL\u5b57\u7b26\u96c6\u548c\u6392\u5e8f \u65e9\u671fMySQL\u7248\u672c\u9ed8\u8ba4\u4e3alatin1\uff0c\u4eceMySQL8.0\u5f00\u59cb\u9ed8\u8ba4\u5b57\u7b26\u96c6\u5df2\u7ecf\u4e3a utf8mb4\u3002\u5efa\u8bae\u9ed8\u8ba4\u5b57\u7b26\u96c6\u7edf\u4e00\u6539\u6210utf8mb4\u3002 \u67e5\u770b\u6240\u6709\u5b57\u7b26\u96c6\uff1a \u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\uff1a \u67e5\u770b\u6240\u6709\u6392\u5e8f\u89c4\u5219\uff1a \u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u6392\u5e8f\u89c4\u5219&#8230;<\/p>\n","protected":false},"author":1,"featured_media":283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[36],"topic":[],"class_list":["post-287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-35","tag-mysql"],"_links":{"self":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=287"}],"version-history":[{"count":2,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/287\/revisions"}],"predecessor-version":[{"id":289,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/287\/revisions\/289"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/media\/283"}],"wp:attachment":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=287"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}