{"id":1097,"date":"2016-08-08T14:29:49","date_gmt":"2016-08-08T06:29:49","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1097"},"modified":"2025-01-06T13:54:13","modified_gmt":"2025-01-06T05:54:13","slug":"mysql-5-5%e5%b0%86%e5%ad%97%e7%ac%a6%e9%9b%86%e4%bb%8eutf8%e5%8d%87%e7%ba%a7%e4%b8%bautf8mb4","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/uncategorized\/mysql-5-5%e5%b0%86%e5%ad%97%e7%ac%a6%e9%9b%86%e4%bb%8eutf8%e5%8d%87%e7%ba%a7%e4%b8%bautf8mb4\/","title":{"rendered":"MySQL 5.5\u5c06\u5b57\u7b26\u96c6\u4eceutf8\u5347\u7ea7\u4e3autf8mb4"},"content":{"rendered":"<h3 id=\"\u4e00\u3001\u5347\u7ea7\u524d\u3002\">\u4e00\u3001\u5347\u7ea7\u524d\u3002<\/h3>\n<pre><code>mysql&gt; SHOW VARIABLES LIKE 'character_set%';\n<\/code><\/pre>\n<pre><code>+--------------------------+--------------------------------------------------------------------+\n| Variable_name            | Value                                                              |\n+--------------------------+--------------------------------------------------------------------+\n| character_set_client     | utf8                                                               |\n| character_set_connection | utf8                                                               |\n| character_set_database   | utf8                                                               |\n| character_set_filesystem | binary                                                             |\n| character_set_results    | utf8                                                               |\n| character_set_server     | utf8                                                               |\n| character_set_system     | utf8                                                               |\n| character_sets_dir       | \/home\/sdkserver\/local\/mysql-5.5.43-linux2.6-x86_64\/share\/charsets\/ |\n+--------------------------+--------------------------------------------------------------------+\n8 rows in set (0.00 sec)\n<\/code><\/pre>\n<pre><code>mysql&gt; SHOW VARIABLES LIKE 'collation%';\n<\/code><\/pre>\n<pre><code>+----------------------+-----------------+\n| Variable_name        | Value           |\n+----------------------+-----------------+\n| collation_connection | utf8_general_ci |\n| collation_database   | utf8_unicode_ci |\n| collation_server     | utf8_unicode_ci |\n+----------------------+-----------------+\n3 rows in set (0.00 sec)\n<\/code><\/pre>\n<h3 id=\"\u4e8c\u3001\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u3002\">\u4e8c\u3001\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u3002<\/h3>\n<p>\u6253\u5f00MySQL\u7684\u914d\u7f6e\u6587\u4ef6\uff0c\u5c06\u5b57\u7b26\u96c6\u7684\u914d\u7f6e\u4fee\u6539\u6210\u5982\u4e0b\uff1a<\/p>\n<pre><code>[client]  \ndefault-character-set = utf8mb4\n\n[mysql]  \ndefault-character-set = utf8mb4\n\n[mysqld]  \ncharacter-set-client-handshake = FALSE\ncharacter-set-server = utf8mb4\ncollation-server = utf8mb4_general_ci\ninit_connect='SET NAMES utf8mb4'\n<\/code><\/pre>\n<h3 id=\"\u4e09\u3001\u5347\u7ea7\u540e\u3002\">\u4e09\u3001\u5347\u7ea7\u540e\u3002<\/h3>\n<pre><code>mysql&gt; SHOW VARIABLES LIKE 'character_set%';\n<\/code><\/pre>\n<pre><code>+--------------------------+--------------------------------------------------------------------+\n| Variable_name            | Value                                                              |\n+--------------------------+--------------------------------------------------------------------+\n| character_set_client     | utf8mb4                                                            |\n| character_set_connection | utf8mb4                                                            |\n| character_set_database   | utf8mb4                                                            |\n| character_set_filesystem | binary                                                             |\n| character_set_results    | utf8mb4                                                            |\n| character_set_server     | utf8mb4                                                            |\n| character_set_system     | utf8                                                               |\n| character_sets_dir       | \/home\/nieyong\/local\/mysql-5.5.43\/share\/charsets\/                   |\n+--------------------------+--------------------------------------------------------------------+\n8 rows in set (0.00 sec)\n<\/code><\/pre>\n<pre><code>mysql&gt; SHOW VARIABLES LIKE 'collation%';\n<\/code><\/pre>\n<pre><code>+----------------------+--------------------+\n| Variable_name        | Value              |\n+----------------------+--------------------+\n| collation_connection | utf8mb4_general_ci |\n| collation_database   | utf8mb4_general_ci |\n| collation_server     | utf8mb4_general_ci |\n+----------------------+--------------------+\n3 rows in set (0.00 sec)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u5347\u7ea7\u524d\u3002 mysql&gt; SHOW VARIABLES LIKE &#8216;character_set%&#8217;;  &#8230; <a title=\"MySQL 5.5\u5c06\u5b57\u7b26\u96c6\u4eceutf8\u5347\u7ea7\u4e3autf8mb4\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/uncategorized\/mysql-5-5%e5%b0%86%e5%ad%97%e7%ac%a6%e9%9b%86%e4%bb%8eutf8%e5%8d%87%e7%ba%a7%e4%b8%bautf8mb4\/\" aria-label=\"\u9605\u8bfb MySQL 5.5\u5c06\u5b57\u7b26\u96c6\u4eceutf8\u5347\u7ea7\u4e3autf8mb4\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[45,381],"class_list":["post-1097","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-mysql","tag-utf8"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1097"}],"version-history":[{"count":2,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1097\/revisions"}],"predecessor-version":[{"id":8842,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1097\/revisions\/8842"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}