Mysql\u4e2dutf8_general_ci\u4e0eutf8_unicode_ci\u6709\u4ec0\u4e48\u533a\u522b\u5462\uff1f\u5728\u7f16\u7a0b\u8bed\u8a00\u4e2d\uff0c\u901a\u5e38\u7528unicode\u5bf9\u4e2d\u6587\u5b57\u7b26\u505a\u5904\u7406\uff0c\u9632\u6b62\u51fa\u73b0\u4e71\u7801\uff0c\u90a3\u4e48\u5728MySQL\u91cc\uff0c\u4e3a\u4ec0\u4e48\u5927\u5bb6\u90fd\u4f7f\u7528utf8_general_ci\u800c\u4e0d\u662futf8_unicode_ci\u5462\uff1f<\/p>\n
\u7528\u4e86\u8fd9\u4e48\u957f\u65f6\u95f4\uff0c\u53d1\u73b0\u81ea\u5df1\u7adf\u7136\u4e0d\u77e5\u9053utf_bin\u548cutf_general_ci\u8fd9\u4e24\u8005\u5230\u5e95\u6709\u4ec0\u4e48\u533a\u522b\u3002\u3002
\nci\u662f case insensitive, \u5373 “\u5927\u5c0f\u5199\u4e0d\u654f\u611f”, a \u548c A \u4f1a\u5728\u5b57\u7b26\u5224\u65ad\u4e2d\u4f1a\u88ab\u5f53\u505a\u4e00\u6837\u7684;
\nbin \u662f\u4e8c\u8fdb\u5236, a \u548c A \u4f1a\u522b\u533a\u522b\u5bf9\u5f85.
\n\u4f8b\u5982\u4f60\u8fd0\u884c:
\nSELECT * FROM table WHERE txt = ‘a’
\n\u90a3\u4e48\u5728utf8_bin\u4e2d\u4f60\u5c31\u627e\u4e0d\u5230 txt = ‘A’ \u7684\u90a3\u4e00\u884c, \u800c utf8_general_ci \u5219\u53ef\u4ee5.
\nutf8_general_ci \u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0c\u8fd9\u4e2a\u4f60\u5728\u6ce8\u518c\u7528\u6237\u540d\u548c\u90ae\u7bb1\u7684\u65f6\u5019\u5c31\u8981\u4f7f\u7528\u3002
\nutf8_general_cs \u533a\u5206\u5927\u5c0f\u5199\uff0c\u5982\u679c\u7528\u6237\u540d\u548c\u90ae\u7bb1\u7528\u8fd9\u4e2a \u5c31\u4f1a\u7167\u6210\u4e0d\u826f\u540e\u679c
\nutf8_bin:\u5b57\u7b26\u4e32\u6bcf\u4e2a\u5b57\u7b26\u4e32\u7528\u4e8c\u8fdb\u5236\u6570\u636e\u7f16\u8bd1\u5b58\u50a8\u3002 \u533a\u5206\u5927\u5c0f\u5199\uff0c\u800c\u4e14\u53ef\u4ee5\u5b58\u4e8c\u8fdb\u5236\u7684\u5185\u5bb9<\/p>\n
\u4e00\u3001\u5b98\u65b9\u6587\u6863\u8bf4\u660e
\n\u4e0b\u9762\u6458\u5f55\u4e00\u4e0bMysql 5.1\u4e2d\u6587\u624b\u518c\u4e2d\u5173\u4e8eutf8_unicode_ci\u4e0eutf8_general_ci\u7684\u8bf4\u660e\uff1a
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:<\/p>\n
\u5f53\u524d\uff0cutf8_unicode_ci\u6821\u5bf9\u89c4\u5219\u4ec5\u90e8\u5206\u652f\u6301Unicode\u6821\u5bf9\u89c4\u5219\u7b97\u6cd5\u3002\u4e00\u4e9b\u5b57\u7b26\u8fd8\u662f\u4e0d\u80fd\u652f\u6301\u3002\u5e76\u4e14\uff0c\u4e0d\u80fd\u5b8c\u5168\u652f\u6301\u7ec4\u5408\u7684\u8bb0\u53f7\u3002\u8fd9\u4e3b\u8981\u5f71\u54cd\u8d8a\u5357\u548c\u4fc4\u7f57\u65af\u7684\u4e00\u4e9b\u5c11\u6570\u6c11\u65cf\u8bed\u8a00\uff0c\u5982\uff1aUdmurt \u3001Tatar\u3001Bashkir\u548cMari\u3002<\/p>\n
utf8_unicode_ci\u7684\u6700\u4e3b\u8981\u7684\u7279\u8272\u662f\u652f\u6301\u6269\u5c55\uff0c\u5373\u5f53\u628a\u4e00\u4e2a\u5b57\u6bcd\u770b\u4f5c\u4e0e\u5176\u5b83\u5b57\u6bcd\u7ec4\u5408\u76f8\u7b49\u65f6\u3002\u4f8b\u5982\uff0c\u5728\u5fb7\u8bed\u548c\u4e00\u4e9b\u5176\u5b83\u8bed\u8a00\u4e2d\u2018\u00df’\u7b49\u4e8e\u2018ss’\u3002<\/p>\n
utf8_general_ci\u662f\u4e00\u4e2a\u9057\u7559\u7684 \u6821\u5bf9\u89c4\u5219\uff0c\u4e0d\u652f\u6301\u6269\u5c55\u3002\u5b83\u4ec5\u80fd\u591f\u5728\u5b57\u7b26\u4e4b\u95f4\u8fdb\u884c\u9010\u4e2a\u6bd4\u8f83\u3002\u8fd9\u610f\u5473\u7740utf8_general_ci\u6821\u5bf9\u89c4\u5219\u8fdb\u884c\u7684\u6bd4\u8f83\u901f\u5ea6\u5f88\u5feb\uff0c\u4f46\u662f\u4e0e\u4f7f\u7528utf8_unicode_ci\u7684 \u6821\u5bf9\u89c4\u5219\u76f8\u6bd4\uff0c\u6bd4\u8f83\u6b63\u786e\u6027\u8f83\u5dee\uff09\u3002<\/p>\n
\u4f8b\u5982\uff0c\u4f7f\u7528utf8_general_ci\u548cutf8_unicode_ci\u4e24\u79cd \u6821\u5bf9\u89c4\u5219\u4e0b\u9762\u7684\u6bd4\u8f83\u76f8\u7b49\uff1a
\n \u00c4 = A
\n \u00d6 = O
\n \u00dc = U<\/p>\n
\u4e24\u79cd\u6821\u5bf9\u89c4\u5219\u4e4b\u95f4\u7684\u533a\u522b\u662f\uff0c\u5bf9\u4e8eutf8_general_ci\u4e0b\u9762\u7684\u7b49\u5f0f\u6210\u7acb\uff1a
\n \u00df = s<\/p>\n
\u4f46\u662f\uff0c\u5bf9\u4e8eutf8_unicode_ci\u4e0b\u9762\u7b49\u5f0f\u6210\u7acb\uff1a
\n \u00df = ss<\/p>\n
\u5bf9\u4e8e\u4e00\u79cd\u8bed\u8a00\u4ec5\u5f53\u4f7f\u7528utf8_unicode_ci\u6392\u5e8f\u505a\u7684\u4e0d\u597d\u65f6\uff0c\u624d\u6267\u884c\u4e0e\u5177\u4f53\u8bed\u8a00\u76f8\u5173\u7684utf8\u5b57\u7b26\u96c6 \u6821\u5bf9\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u5bf9\u4e8e\u5fb7\u8bed\u548c\u6cd5\u8bed\uff0cutf8_unicode_ci\u5de5\u4f5c\u7684\u5f88\u597d\uff0c\u56e0\u6b64\u4e0d\u518d\u9700\u8981\u4e3a\u8fd9\u4e24\u79cd\u8bed\u8a00\u521b\u5efa\u7279\u6b8a\u7684utf8\u6821\u5bf9\u89c4\u5219\u3002<\/p>\n
utf8_general_ci\u4e5f\u9002\u7528\u4e0e\u5fb7\u8bed\u548c\u6cd5\u8bed\uff0c\u9664\u4e86\u2018\u00df’\u7b49\u4e8e\u2018s’\uff0c\u800c\u4e0d\u662f\u2018ss’\u4e4b\u5916\u3002\u5982\u679c\u4f60\u7684\u5e94\u7528\u80fd\u591f\u63a5\u53d7\u8fd9\u4e9b\uff0c\u90a3\u4e48\u5e94\u8be5\u4f7f\u7528utf8_general_ci\uff0c\u56e0\u4e3a\u5b83\u901f\u5ea6\u5feb\u3002\u5426\u5219\uff0c\u4f7f\u7528utf8_unicode_ci\uff0c\u56e0\u4e3a\u5b83\u6bd4\u8f83\u51c6\u786e\u3002<\/p>\n
\u5982\u679c\u4f60\u60f3\u4f7f\u7528gb2312\u7f16\u7801,\u90a3\u4e48\u5efa\u8bae\u4f60\u4f7f\u7528latin1\u4f5c\u4e3a\u6570\u636e\u8868\u7684\u9ed8\u8ba4\u5b57\u7b26\u96c6,\u8fd9\u6837\u5c31\u80fd\u76f4\u63a5\u7528\u4e2d\u6587\u5728\u547d\u4ee4\u884c\u5de5\u5177\u4e2d\u63d2\u5165\u6570\u636e,\u5e76\u4e14\u53ef\u4ee5\u76f4\u63a5\u663e\u793a\u51fa\u6765.\u800c\u4e0d\u8981\u4f7f\u7528gb2312\u6216\u8005gbk\u7b49\u5b57\u7b26\u96c6,\u5982\u679c\u62c5\u5fc3\u67e5\u8be2\u6392\u5e8f\u7b49\u95ee\u9898,\u53ef\u4ee5\u4f7f\u7528binary\u5c5e\u6027\u7ea6\u675f,\u4f8b\u5982:
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\ncreate table my_table ( name varchar(20) binary not null default ”)type=myisam default charset latin1;<\/p>\n
\u4e8c\u3001\u7b80\u77ed\u603b\u7ed3
\nutf8_unicode_ci\u548cutf8_general_ci\u5bf9\u4e2d\u3001\u82f1\u6587\u6765\u8bf4\u6ca1\u6709\u5b9e\u8d28\u7684\u5dee\u522b\u3002
\nutf8_general_ci\u6821\u5bf9\u901f\u5ea6\u5feb\uff0c\u4f46\u51c6\u786e\u5ea6\u7a0d\u5dee\u3002
\nutf8_unicode_ci\u51c6\u786e\u5ea6\u9ad8\uff0c\u4f46\u6821\u5bf9\u901f\u5ea6\u7a0d\u6162\u3002<\/p>\n
\u5982\u679c\u4f60\u7684\u5e94\u7528\u6709\u5fb7\u8bed\u3001\u6cd5\u8bed\u6216\u8005\u4fc4\u8bed\uff0c\u8bf7\u4e00\u5b9a\u4f7f\u7528utf8_unicode_ci\u3002\u4e00\u822c\u7528utf8_general_ci\u5c31\u591f\u4e86\uff0c\u5230\u73b0\u5728\u4e5f\u6ca1\u53d1\u73b0\u95ee\u9898\u3002\u3002\u3002<\/p>\n
\u4e09\u3001\u8be6\u7ec6\u603b\u7ed3<\/p>\n
1\u3001\u5bf9\u4e8e\u4e00\u79cd\u8bed\u8a00\u4ec5\u5f53\u4f7f\u7528utf8_unicode_ci\u6392\u5e8f\u505a\u7684\u4e0d\u597d\u65f6\uff0c\u624d\u6267\u884c\u4e0e\u5177\u4f53\u8bed\u8a00\u76f8\u5173\u7684utf8\u5b57\u7b26\u96c6\u6821\u5bf9\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u5bf9\u4e8e\u5fb7\u8bed\u548c\u6cd5\u8bed\uff0cutf8_unicode_ci\u5de5\u4f5c\u7684\u5f88\u597d\uff0c\u56e0\u6b64\u4e0d\u518d\u9700\u8981\u4e3a\u8fd9\u4e24\u79cd\u8bed\u8a00\u521b\u5efa\u7279\u6b8a\u7684utf8\u6821\u5bf9\u89c4\u5219\u3002
\n2\u3001utf8_general_ci\u4e5f\u9002\u7528\u4e0e\u5fb7\u8bed\u548c\u6cd5\u8bed\uff0c\u9664\u4e86\u2018?’\u7b49\u4e8e\u2018s’\uff0c\u800c\u4e0d\u662f\u2018ss’\u4e4b\u5916\u3002\u5982\u679c\u4f60\u7684\u5e94\u7528\u80fd\u591f\u63a5\u53d7\u8fd9\u4e9b\uff0c\u90a3\u4e48\u5e94\u8be5\u4f7f\u7528 utf8_general_ci\uff0c\u56e0\u4e3a\u5b83\u901f\u5ea6\u5feb\u3002\u5426\u5219\uff0c\u4f7f\u7528utf8_unicode_ci\uff0c\u56e0\u4e3a\u5b83\u6bd4\u8f83\u51c6\u786e\u3002<\/p>\n
\u7528\u4e00\u53e5\u8bdd\u6982\u51b5\u4e0a\u9762\u8fd9\u6bb5\u8bdd\uff1autf8_unicode_ci\u6bd4\u8f83\u51c6\u786e\uff0cutf8_general_ci\u901f\u5ea6\u6bd4\u8f83\u5feb\u3002\u901a\u5e38\u60c5\u51b5\u4e0b utf8_general_ci\u7684\u51c6\u786e\u6027\u5c31\u591f\u6211\u4eec\u7528\u7684\u4e86\uff0c\u5728\u6211\u770b\u8fc7\u5f88\u591a\u7a0b\u5e8f\u6e90\u7801\u540e\uff0c\u53d1\u73b0\u5b83\u4eec\u5927\u591a\u6570\u4e5f\u7528\u7684\u662futf8_general_ci\uff0c\u6240\u4ee5\u65b0\u5efa\u6570\u636e \u5e93\u65f6\u4e00\u822c\u9009\u7528utf8_general_ci\u5c31\u53ef\u4ee5\u4e86<\/p>\n
\u56db\u3001\u5982\u4f55\u5728MySQL5.0\u4e2d\u4f7f\u7528UTF8
\n\u5728 my.cnf\u4e2d\u589e\u52a0\u4e0b\u5217\u53c2\u6570
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:<\/p>\n
[mysqld]
\ninit_connect=’SET NAMES utf8\u2032
\ndefault-character-set=utf8
\ndefault-collation = utf8_general_ci<\/p>\n
\u6267\u884c\u67e5\u8be2 mysql> show variables; \u76f8\u5173\u5982\u4e0b:
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\ncharacter_set_client | utf8
\ncharacter_set_connection | utf8
\ncharacter_set_database | utf8
\ncharacter_set_results | utf8
\ncharacter_set_server | utf8
\ncharacter_set_system | utf8<\/p>\n
collation_connection | utf8_general_ci
\ncollation_database | utf8_general_ci
\ncollation_server | utf8_general_ci<\/p>\n
\u4e2a\u4eba\u89c1\u89e3\uff0c\u5bf9\u4e8e\u6570\u636e\u5e93\u7684\u4f7f\u7528\uff0cutf8 – general \u5df2\u7ecf\u8db3\u591f\u7684\u51c6\u786e\uff0c\u5e76\u4e14\u76f8\u8f83\u4e0e utf8 – unicode\u901f\u5ea6\u4e0a\u6709\u4f18\u52bf\uff0c\u56fa\u53ef\u653e\u5fc3\u91c7\u7528\u4e4b<\/p>\n
\u96441\uff1a\u65e7\u6570\u636e\u5347\u7ea7\u529e\u6cd5
\n\u4ee5\u539f\u6765\u7684\u5b57\u7b26\u96c6\u4e3alatin1\u4e3a\u4f8b\uff0c\u5347\u7ea7\u6210\u4e3autf8\u7684\u5b57\u7b26\u96c6\u3002\u539f\u6765\u7684\u8868: old_table (default charset=latin1)\uff0c\u65b0\u8868\uff1anew_table(default charset=utf8)\u3002
\n\u7b2c\u4e00\u6b65\uff1a\u5bfc\u51fa\u65e7\u6570\u636e
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\nmysqldump –default-character-set=latin1 -hlocalhost -uroot -B my_db –tables old_table > old.sql<\/p>\n
\u7b2c\u4e8c\u6b65\uff1a\u8f6c\u6362\u7f16\u7801(\u7c7b\u4f3cunix\/linux\u73af\u5883\u4e0b)
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\niconv -t utf-8 -f gb2312 -c old.sql > new.sql<\/p>\n
\u6216\u8005\u53ef\u4ee5\u53bb\u6389 -f \u53c2\u6570\uff0c\u8ba9iconv\u81ea\u52a8\u5224\u65ad\u539f\u6765\u7684\u5b57\u7b26\u96c6
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\niconv -t utf-8 -c old.sql > new.sql<\/p>\n
\u5728\u8fd9\u91cc\uff0c\u5047\u5b9a\u539f\u6765\u7684\u6570\u636e\u9ed8\u8ba4\u662fgb2312\u7f16\u7801\u3002
\n\u7b2c\u4e09\u6b65\uff1a\u5bfc\u5165
\n\u4fee\u6539old.sql\uff0c\u5728\u63d2\u5165\/\u66f4\u65b0\u8bed\u53e5\u5f00\u59cb\u4e4b\u524d\uff0c\u589e\u52a0\u4e00\u6761sql\u8bed\u53e5\uff1a “SET NAMES utf8;”\uff0c\u4fdd\u5b58\u3002
\n\u590d\u5236\u4ee3\u7801 \u4ee3\u7801\u5982\u4e0b:
\nmysql -hlocalhost -uroot my_db < new.sql\n\n\u5927\u529f\u544a\u6210\uff01\uff01\n\n\u96442\uff1a\u652f\u6301\u67e5\u770butf8\u5b57\u7b26\u96c6\u7684MySQL\u5ba2\u6237\u7aef\u6709\n1.) MySQL-Front\uff0c\u636e\u8bf4\u8fd9\u4e2a\u9879\u76ee\u5df2\u7ecf\u88abMySQL AB\u52d2\u4ee4\u505c\u6b62\u4e86\uff0c\u4e0d\u77e5\u4e3a\u4f55\uff0c\u5982\u679c\u56fd\u5185\u8fd8\u6709\u4e0d\u5c11\u7834\u89e3\u7248\u53ef\u4ee5\u4e0b\u8f7d\uff08\u4e0d\u4ee3\u8868\u6211\u63a8\u8350\u4f7f\u7528\u7834\u89e3\u7248 :-P\uff09\u3002\n2.) Navicat\uff0c\u53e6\u4e00\u6b3e\u975e\u5e38\u4e0d\u9519\u7684MySQL\u5ba2\u6237\u7aef\uff0c\u6c49\u5316\u7248\u521a\u51fa\u6765\uff0c\u8fd8\u9080\u8bf7\u6211\u8bd5\u7528\u8fc7\uff0c\u603b\u7684\u6765\u8bf4\u8fd8\u662f\u4e0d\u9519\u7684\uff0c\u4e0d\u8fc7\u4e5f\u9700\u8981\u4ed8\u8d39\u3002\n3.) PhpMyAdmin\uff0c\u5f00\u6e90\u7684php\u9879\u76ee\uff0c\u975e\u5e38\u597d\u3002\n4.) Linux\u4e0b\u7684\u7ec8\u7aef\u5de5\u5177\uff08Linux terminal\uff09\uff0c\u628a\u7ec8\u7aef\u7684\u5b57\u7b26\u96c6\u8bbe\u7f6e\u4e3autf8\uff0c\u8fde\u63a5\u5230MySQL\u4e4b\u540e\uff0c\u6267\u884c SET NAMES UTF8; \u4e5f\u80fd\u8bfb\u5199utf8\u6570\u636e\u4e86\u3002\n<\/p>\n","protected":false},"excerpt":{"rendered":"