{"id":133,"title":"\u5b57\u7b26\u96c6\u4e0e\u6821\u5bf9\u96c6","good":0,"bad":0,"hit":2013,"created_at":"2014-12-22 10:52:49","content":"<p>\u5b57\u7b26\u96c6 <br\/><\/p><p>\u5b57\u7b26\u96c6\uff0c\u63cf\u8ff0\u53ef\u89c1\u5230\u7684\u56fe\u5f62\uff0c\u5728\u5b58\u50a8\u548c\u4f20\u8f93\u65f6\u4f7f\u7528\u7684\u7f16\u7801\u79f0\u4e4b\u4e3a\u5b57\u7b26\u96c6\uff01<\/p><p>\u6307\u7684\u662f\uff1a<\/p><p>\u56fe\u5f62\u4e0e\u7f16\u7801\u4e4b\u95f4\u7684\u5bf9\u5e94\u5173\u7cfb\uff01 <br\/><\/p><p>\u5b57 =&gt; 11100101 11100001 00010100<\/p><p><br\/><\/p><p>\u6570\u636e\u5b58\u50a8\u7684\u7f16\u7801<\/p><p>\u6570\u636e\u662f\u5b58\u50a8\u5728\u670d\u52a1\u5668\u7aef\u7684\uff01\u7a76\u7adf\u662f\u4ee5\u54ea\u79cd\u7f16\u7801\u4fdd\u5b58\u7684\uff0c\u600e\u4e48\u51b3\u5b9a\uff1f<\/p><p>\u6570\u636e\u662f\u6700\u7ec8\u8981\u6620\u5c04\uff08\u4fdd\u5b58\uff09\u5230\u5b57\u6bb5\u7684\u5c42\u9762\u4e0a\uff01\u56e0\u6b64\u51b3\u5b9a\u6570\u636e\u7684\u7f16\u7801\uff0c\u4e5f\u662f\u6700\u7ec8\u7531\u5b57\u6bb5\u6765\u51b3\u5b9a\uff01<\/p><p>&nbsp;<\/p><p>\u786e\u5b9a\u6570\u636e\u7684\u5b58\u50a8\u7f16\u7801\u662f\u7531\u4ee5\u4e0b\u7684\u65b9\u6848\u5b8c\u6210\u7684\uff1a<\/p><p>1\uff0c&nbsp; \u5148\u770b\u5b57\u6bb5\u7684\u7f16\u7801\uff01\u5982\u679c\u5b58\u5728\u5219\u786e\u5b9a\u5b8c\u6bd5\uff01<\/p><p>2\uff0c&nbsp; \u5982\u679c\u5b57\u6bb5\u6ca1\u6709\u8bbe\u7f6e\u7f16\u7801\uff0c\u67e5\u770b\u8868\u7684\u7f16\u7801\uff0c\u5982\u679c\u6709\uff0c\u5219\u786e\u5b9a\u6570\u636e\u7f16\u7801\uff01<\/p><p>3\uff0c&nbsp; \u5982\u679c\u8868\u6ca1\u6709\u7f16\u7801\uff0c\u67e5\u770b\u5e93\u7684\u7f16\u7801\uff0c\u5982\u679c\u6709\uff0c\u5219\u786e\u5b9a\u6570\u636e\u7f16\u7801\uff01<\/p><p>4\uff0c&nbsp; \u5982\u679c\u5e93\u4e5f\u6ca1\u6709\u7f16\u7801\uff0c\u5219\u6709\u670d\u52a1\u5668\u7a0b\u5e8f\u786e\u5b9a\uff01<\/p><p><br\/><\/p><p>\u5ba2\u6237\u7aef\u64cd\u4f5c\uff0c\u67e5\u8be2\u7684\u7f16\u7801 <br\/><\/p><p>\u5728\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u5668\u7aef\u4ea4\u4e92\u65f6\uff0c\u5b58\u5728\u4e24\u4e2a\u91cd\u8981\u7684\u7f16\u7801\uff1a<\/p><p>1\uff0c&nbsp; \u5ba2\u6237\u7aef\u53d1\u9001\u6570\u636e\u7684\u7f16\u7801<\/p><p>2\uff0c&nbsp; \u5ba2\u6237\u7aef\u63a5\u6536\u5230\u670d\u52a1\u5668\u6570\u636e\u7f16\u7801\uff01 <br\/><\/p><p><span style=\"color: rgb(255, 0, 0);\">\u53ef\u4ee5\u901a\u8fc7 show variables like \u2018character_set_%\u2019\u5c55\u793a\u4ee5character_set\u5f00\u5934\u53d8\u91cf\uff0c\u5176\u4e2d\u5c31\u6709\u4e0a\u9762\u7684\u4e24\u4e2a\u503c\uff1a<\/span><\/p><p><br\/><\/p><p><br\/><\/p><p>\u4f7f\u7528 set \u53d8\u91cf\u540d = \u53d8\u91cf\u503c\u7684\u5f62\u5f0f\u66f4\u6539\u53d8\u91cf\u503c\uff01<\/p><p>set character_set_client=gbk;<\/p><p>set character_set_results=gbk; <br\/><\/p><p>set names gbk\uff0c\u5c31\u662f\u4e00\u4e2a\u5feb\u6377\u64cd\u4f5c\uff0c\u5c06\u4e0a\u9762\u4e24\u4e2a\u914d\u7f6e\u540c\u65f6\u66f4\u6539\u6210\u76ee\u6807\u7f16\u7801\uff01<\/p><p>set names gbk|utf8 \u53d6\u51b3\u4e8e\uff0c\u5ba2\u6237\u7aef\u6240\u80fd\u63a5\u53d7\u7684\u7f16\u7801\uff01<\/p><p><br\/><\/p><p>\u5ba2\u6237\u7aef\u53d1\u9001\u4e00\u6761sql\uff1a<\/p><p>\u5ba2\u6237\u7aef\u7f16\u7801\uff08character_set_client\uff09-&gt;\u8fde\u63a5\u5c42\u7f16\u7801\uff08characger_set_connection\uff09-&gt;\u670d\u52a1\u5668\u5185\u90e8\u7f16\u7801\uff08server_internal\uff09<\/p><p>&nbsp;<\/p><p>\u670d\u52a1\u5668\u7aef\u53d1\u9001\u7ed3\u679c\uff1a<\/p><p>\u670d\u52a1\u5668\u5185\u90e8\u7f16\u7801\uff08server_internal\uff09-&gt;\u8fde\u63a5\u5c42\u7f16\u7801\uff08characger_set_connection\uff09-&gt;\u5ba2\u6237\u7aef\u63a5\u6536\u7684\u7ed3\u679c\u7f16\u7801\uff08character_set_results\uff09<\/p><p><\/p><p><br\/><\/p><p>\u6821\u5bf9\u96c6\uff0ccollate<\/p><p>\u6307\u7684\u662f\u5b57\u7b26\u4e4b\u95f4\u7684\u6bd4\u8f83\u5173\u7cfb,\u4e3b\u8981\u7528\u4e8e\u5b57\u6bb5\u95f4\u7684\u6392\u5e8f\uff01<\/p><p><span style=\"color: rgb(255, 0, 0);\">\u5229\u7528 show collation; \u67e5\u770b\u5230\u6240\u6709\u7684\u6821\u5bf9\u96c6\uff01<\/span><\/p><p><span style=\"color: rgb(255, 0, 0);\">\u6821\u5bf9\u96c6\uff0c\u4f9d\u8d56\u4e8e\u5b57\u7b26\u96c6\uff01<\/span><\/p><p>\u6821\u5bf9\u96c6\uff0c\u6307\u7684\u662f\uff0c\u5728\u67d0\u4e2a\u5b57\u7b26\u96c6\u4e0b\uff0c\u5b57\u7b26\u7684\u6392\u5e8f\u5173\u7cfb\u5e94\u8be5\u662f\u4ec0\u4e48\uff0c\u79f0\u4e4b\u4e3a\u6821\u5bf9\u96c6\uff01<\/p><p><br\/><\/p><p>\u6211\u4eec\u5178\u578b\u7684\u9009\u62e9\uff1a<\/p><p>utf8_general_ci;<\/p><p>utf8_unicode_ci;<\/p><p><span style=\"color: rgb(255, 0, 0);\">\u5178\u578b\u7684\u540e\u7f00\uff1a<\/span><\/p><p><span style=\"color: rgb(255, 0, 0);\">_bin \u4e8c\u8fdb\u5236\u7f16\u7801\u5c42\u9762\u76f4\u63a5\u6bd4\u8f83\uff1a<\/span><\/p><p><span style=\"color: rgb(255, 0, 0);\">_ci \u5ffd\u7565\u5927\u5c0f\u5199\uff08\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff09\u6bd4\u8f83<\/span><\/p><p><span style=\"color: rgb(255, 0, 0);\">_cs \u5927\u5c0f\u5199\u654f\u611f\u6bd4\u8f83<\/span><\/p>"}