{"id":3399,"date":"2019-06-04T15:09:44","date_gmt":"2019-06-04T07:09:44","guid":{"rendered":"https:\/\/damogame.cn\/wordpress\/?p=3399"},"modified":"2019-06-04T15:09:44","modified_gmt":"2019-06-04T07:09:44","slug":"mysql%e7%b3%bb%e5%88%97%ef%bc%9autf8_bin%e5%92%8cutf8_general_ci%e7%bc%96%e7%a0%81%e7%9a%84%e5%8c%ba%e5%88%ab","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/3399","title":{"rendered":"MySQL\u7cfb\u5217\uff1autf8_bin\u548cutf8_general_ci\u7f16\u7801\u7684\u533a\u522b"},"content":{"rendered":"

\u539f\u6587\u5730\u5740<\/a><\/p>\n

<\/div>\n
\n
\n

MySQL\u4e2d\u5b58\u5728\u591a\u79cd\u683c\u5f0f\u7684utf8\u7f16\u7801\uff0c\u5176\u4e2d\u6700\u5e38\u89c1\u7684\u4e24\u79cd\u4e3a\uff1a<\/p>\n

    \n
  1. utf8_bin<\/li>\n
  2. utf8_general_ci<\/li>\n<\/ol>\n

    utf8_bin\u5c06\u5b57\u7b26\u4e32\u4e2d\u7684\u6bcf\u4e00\u4e2a\u5b57\u7b26\u7528\u4e8c\u8fdb\u5236\u6570\u636e\u5b58\u50a8\uff0c\u533a\u5206\u5927\u5c0f\u5199;
    \nutf8_genera_ci\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0cci\u4e3acase insensitive\u7684\u7f29\u5199\uff0c\u5373\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0c\u4e3autf8\u9ed8\u8ba4\u7f16\u7801\u3002<\/p>\n

    \u793a\u4f8b\uff1a<\/p>\n

    \n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
     1 CREATE TABLE `t_bin` (\r\n 2 `id` int(11) DEFAULT NULL,\r\n 3 `name` varchar(20) DEFAULT NULL,\r\n 4 UNIQUE KEY `uk_name` (`name`)\r\n 5 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin\uff1b\r\n 6 \r\n 7 CREATE TABLE `t_ci` (\r\n 8 `id` int(11) DEFAULT NULL,\r\n 9 `name` varchar(20) DEFAULT NULL,\r\n10 UNIQUE KEY `uk_name` (`name`)\r\n11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;\r\n12 \r\n13 CREATE TABLE `t_default` (\r\n14 `id` int(11) DEFAULT NULL,\r\n15 `name` varchar(20) DEFAULT NULL,\r\n16 UNIQUE KEY `uk_name` (`name`)\r\n17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/pre>\n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
    \u6267\u884c\u4ee5\u4e0b\u8bed\u53e5\uff1a<\/p>\n
    \n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
    1 insert into t_bin values (1, 'Alex');\r\n2 insert into t_bin values (2, 'alex');\r\n3 \r\n4 insert into t_ci values (1, 'Alex');\r\n5 insert into t_ci values (2, 'alex');\r\n6 \r\n7 insert into t_default values (1, 'Alex');\r\n8 insert into t_default values (2, 'alex');<\/pre>\n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
    \u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
    \n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
     1 root@zow 11:13:44>insert into t_bin values (1, 'Alex');\r\n 2 Query OK, 1 row affected (0.01 sec)\r\n 3 \r\n 4 root@zow 11:14:14>insert into t_bin values (2, 'alex');\r\n 5 Query OK, 1 row affected (0.01 sec)\r\n 6 \r\n 7 root@zow 11:14:17>insert into t_ci values (1, 'Alex');\r\n 8 Query OK, 1 row affected (0.00 sec)\r\n 9 \r\n10 root@zow 11:14:32>insert into t_ci values (2, 'alex');\r\n11 ERROR 1062 (23000): Duplicate entry 'alex' for key 'uk_name'\r\n12 root@zow 11:14:36>insert into t_default values (1, 'Alex');\r\n13 Query OK, 1 row affected (0.01 sec)\r\n14 \r\n15 root@zow 11:14:50>insert into t_default values (2, 'alex');\r\n16 ERROR 1062 (23000): Duplicate entry 'alex' for key 'uk_name'<\/pre>\n
    \"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
    \u5206\u6790\uff1a<\/p>\n
    \u7f16\u7801\u4e3autf8_bin\u65f6\uff0cAlex\u548calex\u88ab\u8ba4\u4e3a\u662f\u4e24\u4e2a\u4e0d\u540c\u7684\u503c\uff0c\u533a\u5206\u5927\u5c0f\u5199\uff1b<\/p>\n
    \u7f16\u7801\u4e3autf8_general_ci\u65f6\uff0c\u5373\u9ed8\u8ba4\u7684\u7f16\u7801\u65f6\uff0cAlex\u548calex\u88ab\u8ba4\u4e3a\u662f\u76f8\u540c\u7684\u503c\uff0c\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002<\/p>\n
     <\/p>\n
    \u6240\u4ee5\u5728\u9009\u62e9\u7f16\u7801\u7684\u65f6\u5019\u5e94\u8be5\u6ce8\u610f\u533a\u5206\u3002<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    \u539f\u6587\u5730\u5740 MySQL\u4e2d\u5b58\u5728\u591a\u79cd\u683c\u5f0f\u7684ut<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[118],"class_list":["post-3399","post","type-post","status-publish","format-standard","hentry","tag-02-"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/3399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=3399"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/3399\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=3399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=3399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=3399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}