鏈?杩戯紝鍦ㄩ」鐩?粍浣跨敤鐨刴ysql鏁版嵁搴撲腑锛屾彃鍏ユ暟鎹?嚭鐜颁贡鐮侊紝鍏充簬杩欎釜闂??鍋氫簡涓嬫?荤粨锛屾垜浠?粠鏈?鍩烘湰鐨勫湴鏂硅?璧凤紝鍒伴敊璇?骇鐢熺殑娣卞眰娆″師鍥犲拰瑙ｅ喅鍔炴硶銆?/p>
鍩烘湰姒傚康
鈥?瀛楃?(Character)鏄?寚浜虹被璇?█涓?渶灏忕殑琛ㄤ箟绗﹀彿銆備緥濡傗?橝'銆佲?橞'绛夛紱
鈥?缁欏畾涓?绯诲垪瀛楃?锛屽?姣忎釜瀛楃?璧嬩簣涓?涓?暟鍊硷紝鐢ㄦ暟鍊兼潵浠ｈ〃瀵瑰簲鐨勫瓧绗︼紝杩欎竴鏁板?煎氨鏄?瓧绗︾殑缂栫爜(Encoding)銆備緥濡傦紝鎴戜滑缁欏瓧绗︹?橝'璧嬩簣鏁板??锛岀粰瀛楃?鈥橞'璧嬩簣鏁板??锛屽垯0灏辨槸瀛楃?鈥橝'鐨勭紪鐮侊紱
鈥?缁欏畾涓?绯诲垪瀛楃?骞惰祴浜堝?搴旂殑缂栫爜鍚庯紝鎵?鏈夎繖浜涘瓧绗﹀拰缂栫爜瀵圭粍鎴愮殑闆嗗悎灏辨槸瀛楃?闆?Character Set)銆備緥濡傦紝缁欏畾瀛楃?鍒楄〃涓簕鈥橝',鈥橞'}鏃讹紝{鈥橝'=>0, 鈥楤鈥?>1}灏辨槸涓?涓?瓧绗﹂泦锛?br>鈥?瀛楃?搴?Collation)鏄?寚鍦ㄥ悓涓?瀛楃?闆嗗唴瀛楃?涔嬮棿鐨勬瘮杈冭?鍒欙紱
鈥?纭?畾瀛楃?搴忓悗锛屾墠鑳藉湪涓?涓?瓧绗﹂泦涓婂畾涔変粈涔堟槸绛変环鐨勫瓧绗︼紝浠ュ強瀛楃?涔嬮棿鐨勫ぇ灏忓叧绯伙紱
鈥?姣忎釜瀛楃?搴忓敮涓?瀵瑰簲涓?绉嶅瓧绗﹂泦锛屼絾涓?涓?瓧绗﹂泦鍙?互瀵瑰簲澶氱?瀛楃?搴忥紝鍏朵腑鏈変竴涓?槸榛樿?瀛楃?搴?Default Collation)锛?br>鈥?MySQL涓?殑瀛楃?搴忓悕绉伴伒浠庡懡鍚嶆儻渚嬶細浠ュ瓧绗﹀簭瀵瑰簲鐨勫瓧绗﹂泦鍚嶇О寮?澶达紱浠?ci(琛ㄧず澶у皬鍐欎笉鏁忔劅)銆乢cs(琛ㄧず澶у皬鍐欐晱鎰?鎴朹bin(琛ㄧず鎸夌紪鐮佸?兼瘮杈?缁撳熬銆備緥濡傦細鍦ㄥ瓧绗﹀簭鈥渦tf8_general_ci鈥濅笅锛屽瓧绗︹?渁鈥濆拰鈥淎鈥濇槸绛変环鐨勶紱
MySQL瀛楃?闆嗚?缃?/strong>
鈥?绯荤粺鍙橀噺锛?br>鈥?character_set_server锛氶粯璁ょ殑鍐呴儴鎿嶄綔瀛楃?闆?br>鈥?character_set_client锛氬?鎴风?鏉ユ簮鏁版嵁浣跨敤鐨勫瓧绗﹂泦
鈥?character_set_connection锛氳繛鎺ュ眰瀛楃?闆?br>鈥?character_set_results锛氭煡璇㈢粨鏋滃瓧绗﹂泦
鈥?character_set_database锛氬綋鍓嶉?変腑鏁版嵁搴撶殑榛樿?瀛楃?闆?br>鈥?character_set_system锛氱郴缁熷厓鏁版嵁(瀛楁?鍚嶇瓑)瀛楃?闆?br>鈥?杩樻湁浠?ollation_寮?澶寸殑鍚屼笂闈㈠?搴旂殑鍙橀噺锛岀敤鏉ユ弿杩板瓧绗﹀簭銆?/p>
鈥?鐢╥ntroducer鎸囧畾鏂囨湰瀛楃?涓茬殑瀛楃?闆嗭細
鈥?鏍煎紡涓猴細[_charset] 鈥檚tring鈥?[COLLATE collation]
鈥?渚嬪?锛?br>聽聽聽聽聽聽 SELECT _latin1 鈥檚tring鈥?
聽聽聽聽聽聽 SELECT _utf8 鈥樹綘濂解??COLLATE utf8_general_ci;
鈥?鐢眎ntroducer淇?グ鐨勬枃鏈?瓧绗︿覆鍦ㄨ?姹傝繃绋嬩腑涓嶇粡杩囧?浣欑殑杞?爜锛岀洿鎺ヨ浆鎹?负鍐呴儴瀛楃?闆嗗?鐞嗐??/p>
MySQL涓?殑瀛楃?闆嗚浆鎹㈣繃绋?/strong>
1. MySQL Server鏀跺埌璇锋眰鏃跺皢璇锋眰鏁版嵁浠巆haracter_set_client杞?崲涓篶haracter_set_connection锛?br>2. 杩涜?鍐呴儴鎿嶄綔鍓嶅皢璇锋眰鏁版嵁浠巆haracter_set_connection杞?崲涓哄唴閮ㄦ搷浣滃瓧绗﹂泦锛屽叾纭?畾鏂规硶濡備笅锛?br>聽聽聽聽聽聽 - 浣跨敤姣忎釜鏁版嵁瀛楁?鐨凜HARACTER SET璁惧畾鍊硷紱
聽聽聽聽聽聽 - 鑻ヤ笂杩板?间笉瀛樺湪锛屽垯浣跨敤瀵瑰簲鏁版嵁琛ㄧ殑DEFAULT CHARACTER SET璁惧畾鍊?MySQL鎵╁睍锛岄潪SQL鏍囧噯)锛?br>聽聽聽聽聽聽 - 鑻ヤ笂杩板?间笉瀛樺湪锛屽垯浣跨敤瀵瑰簲鏁版嵁搴撶殑DEFAULT CHARACTER SET璁惧畾鍊硷紱
聽聽聽聽聽聽 - 鑻ヤ笂杩板?间笉瀛樺湪锛屽垯浣跨敤character_set_server璁惧畾鍊笺??/p>
3. 灏嗘搷浣滅粨鏋滀粠鍐呴儴鎿嶄綔瀛楃?闆嗚浆鎹?负character_set_results銆?/p>
聽
聽聽鎴戜滑鐜板湪鍥炶繃澶存潵鍒嗘瀽涓嬫垜浠?骇鐢熺殑涔辩爜闂??锛?/span>
聽聽聽聽聽聽聽聽聽 a 鎴戜滑鐨勫瓧娈垫病鏈夎?缃?瓧绗﹂泦锛屽洜姝や娇鐢ㄨ〃鐨勬暟鎹?泦
聽聽聽聽聽聽聽聽聽 b 鎴戜滑鐨勮〃娌℃湁鎸囧畾瀛楃?闆嗭紝榛樿?浣跨敤鏁版嵁搴撳瓨鐨勫瓧绗﹂泦
聽聽聽聽聽聽聽聽聽 c 鎴戜滑鐨勬暟鎹?簱鍦ㄥ垱寤虹殑鏃跺?欐病鏈夋寚瀹氬瓧绗﹂泦锛屽洜姝や娇鐢╟haracter_set_server璁惧畾鍊?/span>
聽聽聽聽聽聽聽聽聽 d 鎴戜滑娌℃湁鐗规剰鍘讳慨鏀筩haracter_set_server鐨勬寚瀹氬瓧绗﹂泦锛屽洜姝や娇鐢╩ysql榛樿?
聽聽聽聽聽聽聽聽聽 e mysql榛樿?鐨勫瓧绗﹂泦鏄痩atin1锛屽洜姝わ紝鎴戜滑浣跨敤浜唋atin1瀛楃?闆嗭紝鑰屾垜浠琧haracter_set_connection鐨勫瓧绗﹂泦鏄疷TF-8锛屾彃鍏ヤ腑鏂囦贡鐮佷篃鍐嶆墍闅惧厤浜嗐??/span>
甯歌?闂??瑙ｆ瀽
鈥?FAQ-1 鍚戦粯璁ゅ瓧绗﹂泦涓簎tf8鐨勬暟鎹?〃鎻掑叆utf8缂栫爜鐨勬暟鎹?墠娌℃湁璁剧疆杩炴帴瀛楃?闆嗭紝鏌ヨ?鏃惰?缃?繛鎺ュ瓧绗﹂泦涓簎tf8
聽聽聽聽 鈥?鎻掑叆鏃舵牴鎹甅ySQL鏈嶅姟鍣ㄧ殑榛樿?璁剧疆锛宑haracter_set_client銆乧haracter_set_connection鍜宑haracter_set_results鍧囦负latin1锛?br>聽聽聽聽 鈥?鎻掑叆鎿嶄綔鐨勬暟鎹?皢缁忚繃latin1=>latin1=>utf8鐨勫瓧绗﹂泦杞?崲杩囩▼锛岃繖涓?杩囩▼涓?瘡涓?彃鍏ョ殑姹夊瓧閮戒細浠庡師濮嬬殑3涓?瓧鑺傚彉鎴?涓?瓧鑺備繚瀛橈紱
聽聽聽聽 鈥?鏌ヨ?鏃剁殑缁撴灉灏嗙粡杩噓tf8=>utf8鐨勫瓧绗﹂泦杞?崲杩囩▼锛屽皢淇濆瓨鐨?涓?瓧鑺傚師灏佷笉鍔ㄨ繑鍥烇紝浜х敓涔辩爜銆傚弬鑰冧笅鍥撅細 
鈥?鍚戦粯璁ゅ瓧绗﹂泦涓簂atin1鐨勬暟鎹?〃鎻掑叆utf8缂栫爜鐨勬暟鎹?墠璁剧疆浜嗚繛鎺ュ瓧绗﹂泦涓簎tf8锛?span style="color: #ff0000;">鎴戜滑閬囧埌鐨勯敊璇?氨鏄?睘浜庤繖涓?绉?/strong>锛?br>聽聽聽聽 鈥?鎻掑叆鏃舵牴鎹?繛鎺ュ瓧绗﹂泦璁剧疆锛宑haracter_set_client銆乧haracter_set_connection鍜宑haracter_set_results鍧囦负utf8锛?br>聽聽聽聽 --鎻掑叆鏁版嵁灏嗙粡杩噓tf8=>utf8=>latin1鐨勫瓧绗﹂泦杞?崲锛岃嫢鍘熷?鏁版嵁涓?惈鏈塡u0000~\u00ff鑼冨洿浠ュ?鐨?Unicode瀛楃?锛屼細鍥犱负鏃犳硶鍦╨atin1瀛楃?闆嗕腑琛ㄧず鑰岃?杞?崲涓衡??鈥?0脳3F)绗﹀彿锛屼互鍚庢煡璇㈡椂涓嶇?杩炴帴瀛楃?闆嗚?缃??浣曢兘鏃犳硶鎭㈠?鍏跺唴瀹逛簡銆傝浆 鎹㈣繃绋嬪?涓嬪浘锛毬?
聽
妫?娴嬪瓧绗﹂泦闂??鐨勪竴浜涙墜娈?/strong>
聽聽聽 鈥?SHOW CHARACTER SET;
聽聽聽 鈥?SHOW COLLATION;
聽聽聽 鈥?SHOW VARIABLES LIKE 鈥榗haracter%鈥?
聽聽聽 鈥?SHOW VARIABLES LIKE 鈥榗ollation%鈥?
聽聽聽 鈥?SQL鍑芥暟HEX銆丩ENGTH銆丆HAR_LENGTH
聽聽聽 鈥?SQL鍑芥暟CHARSET銆丆OLLATION
聽
浣跨敤MySQL瀛楃?闆嗘椂鐨勫缓璁?/strong>
聽聽聽 鈥?寤虹珛鏁版嵁搴?琛ㄥ拰杩涜?鏁版嵁搴撴搷浣滄椂灏介噺鏄惧紡鎸囧嚭浣跨敤鐨勫瓧绗﹂泦锛岃?屼笉鏄?緷璧栦簬MySQL鐨勯粯璁よ?缃?紝鍚﹀垯MySQL鍗囩骇鏃跺彲鑳藉甫鏉ュ緢澶у洶鎵帮紱
聽聽聽 鈥?鏁版嵁搴撳拰杩炴帴瀛楃?闆嗛兘浣跨敤latin1鏃讹紝铏界劧澶ч儴鍒嗘儏鍐典笅閮藉彲浠ヨВ鍐充贡鐮侀棶棰橈紝浣嗙己鐐规槸鏃犳硶浠ュ瓧绗︿负鍗曚綅鏉ヨ繘琛孲QL鎿嶄綔锛屼竴鑸?儏鍐典笅灏嗘暟鎹?簱鍜岃繛鎺ュ瓧绗﹂泦閮界疆涓簎tf8鏄?緝濂界殑閫夋嫨锛?br>聽聽聽 鈥?浣跨敤mysql CAPI锛坢ysql鎻愪緵C璇?█鎿嶄綔鐨凙PI锛夋椂锛屽垵濮嬪寲鏁版嵁搴撳彞鏌勫悗椹?笂鐢╩ysql_options璁惧畾 MYSQL_SET_CHARSET_NAME灞炴?т负utf8锛岃繖鏍峰氨涓嶇敤鏄惧紡鍦扮敤SET NAMES璇?彞鎸囧畾杩炴帴瀛楃?闆嗭紝涓旂敤mysql_ping閲嶈繛鏂?紑鐨勯暱杩炴帴鏃朵篃浼氭妸杩炴帴瀛楃?闆嗛噸缃?负utf8锛?br>聽聽聽 鈥?瀵逛簬mysql PHP API锛屼竴鑸?〉闈㈢骇鐨凱HP绋嬪簭鎬昏繍琛屾椂闂磋緝鐭?紝鍦ㄨ繛鎺ュ埌鏁版嵁搴撲互鍚庢樉寮忕敤SET NAMES璇?彞璁剧疆涓?娆¤繛鎺ュ瓧绗﹂泦鍗冲彲锛涗絾褰撲娇鐢ㄩ暱杩炴帴鏃讹紝璇锋敞鎰忎繚鎸佽繛鎺ラ?氱晠骞跺湪鏂?紑閲嶈繛鍚庣敤SET NAMES璇?彞鏄惧紡閲嶇疆杩炴帴瀛楃?闆嗐??br>聽
鍏朵粬娉ㄦ剰浜嬮」
聽聽聽 鈥?my.cnf涓?殑default_character_set璁剧疆鍙?奖鍝峬ysql鍛戒护杩炴帴鏈嶅姟鍣ㄦ椂鐨勮繛鎺ュ瓧绗﹂泦锛屼笉浼氬?浣跨敤libmysqlclient搴撶殑搴旂敤绋嬪簭浜х敓浠讳綍浣滅敤锛?br>聽聽聽 鈥?瀵瑰瓧娈佃繘琛岀殑SQL鍑芥暟鎿嶄綔閫氬父閮芥槸浠ュ唴閮ㄦ搷浣滃瓧绗﹂泦杩涜?鐨勶紝涓嶅彈杩炴帴瀛楃?闆嗚?缃?殑褰卞搷銆?br>聽聽聽 鈥?SQL璇?彞涓?殑瑁稿瓧绗︿覆浼氬彈鍒拌繛鎺ュ瓧绗﹂泦鎴杋ntroducer璁剧疆鐨勫奖鍝嶏紝瀵逛簬姣旇緝涔嬬被鐨勬搷浣滃彲鑳戒骇鐢熷畬鍏ㄤ笉鍚岀殑缁撴灉锛岄渶瑕佸皬蹇冿紒
聽
鎬荤粨
聽聽聽 鏍?鎹?笂闈㈢殑鍒嗘瀽鍜屽缓璁?紝鎴戜滑瑙ｅ喅鎴戜滑閬囧埌闂??搴旇?浣跨敤浠?涔堟柟娉曞ぇ瀹跺績閲屽簲璇ユ瘮杈冩竻妤氫簡銆傚?锛屽氨鏄?湪鍒涘缓database鐨勬椂鍊欐寚瀹氬瓧绗﹂泦锛屼笉瑕佸幓閫氳繃淇?敼榛?璁ら厤缃?潵杈惧埌鐩?殑锛屽綋鐒朵綘涔熷彲浠ラ噰鐢ㄦ寚瀹氳〃鐨勫瓧绗﹂泦鐨勫舰寮忥紝浣嗗緢瀹规槗鍑虹幇閬楁紡锛岀壒鍒?槸鍦ㄥ緢澶氫汉閮藉弬涓庤?璁＄殑鏃跺?欙紝鏇村?鏄撶喊婕忋??/span>
聽
聽聽聽 铏界劧涓嶆彁鍊￠?氳繃淇?敼mysql鐨勯粯璁ゅ瓧绗﹂泦鏉ヨВ鍐筹紝浣嗗?浜庡?浣曞幓淇?敼榛樿?瀛楃?闆嗭紝鎴戣繖閲岃繕鏄?粰鍑轰竴浜涙柟娉曪紝浠呬緵澶у?鍙傝?冦??/span>
聽
MySQL榛樿?瀛楃?闆?/strong>
MySQL瀵逛簬瀛楃?闆嗙殑鎸囧畾鍙?互缁嗗寲鍒颁竴涓?暟鎹?簱锛屼竴寮犺〃锛屼竴鍒?浼犵粺鐨勭▼搴忓湪鍒涘缓鏁版嵁搴撳拰鏁版嵁琛ㄦ椂骞舵病鏈変娇鐢ㄩ偅涔堝?鏉傜殑閰嶇疆锛屽畠浠?敤鐨勬槸榛樿?鐨勯厤缃?
聽聽聽 (1)缂栬瘧MySQL 鏃讹紝鎸囧畾浜嗕竴涓?粯璁ょ殑瀛楃?闆嗭紝杩欎釜瀛楃?闆嗘槸 latin1锛?/span>
聽聽聽 (2)瀹夎?MySQL 鏃讹紝鍙?互鍦ㄩ厤缃?枃浠?(my.ini) 涓?寚瀹氫竴涓?粯璁ょ殑鐨勫瓧绗﹂泦锛屽?鏋滄病鎸囧畾锛岃繖涓??肩户鎵胯嚜缂栬瘧鏃舵寚瀹氱殑锛?/span>
聽聽聽 (3)鍚?姩mysqld 鏃讹紝鍙?互鍦ㄥ懡浠よ?鍙傛暟涓?寚瀹氫竴涓?粯璁ょ殑鐨勫瓧绗﹂泦锛屽?鏋滄病鎸囧畾锛岃繖涓??肩户鎵胯嚜閰嶇疆鏂囦欢涓?殑閰嶇疆,姝ゆ椂 character_set_server 琚??瀹氫负杩欎釜榛樿?鐨勫瓧绗﹂泦锛?/span>
聽聽聽 (4)瀹夎? MySQL閫夋嫨澶氳?瑷?鏀?寔锛屽畨瑁呯▼搴忎細鑷?姩鍦ㄩ厤缃?枃浠朵腑鎶奷efault_character_set 璁剧疆涓?UTF-8锛屼繚璇佺己鐪佹儏鍐典笅鎵?鏈夌殑鏁版嵁搴撴墍鏈夎〃鐨勬墍鏈夊垪鐨勯兘鐢?UTF-8 瀛樺偍銆?/span>
鏌ョ湅榛樿?瀛楃?闆?/strong>
聽聽聽 (榛樿?鎯呭喌涓嬶紝mysql鐨勫瓧绗﹂泦鏄痩atin1(ISO_8859_1)锛屽?浣曟煡鐪嬪湪涓婇潰鎴戜滑宸茬粡缁欏嚭浜嗙浉鍏冲懡浠?/span>
淇?敼榛樿?瀛楃?闆?/strong>
(1) 鏈?绠?鍗曠殑淇?敼鏂规硶锛屽氨鏄?慨鏀筸ysql鐨刴y.ini鏂囦欢涓?殑瀛楃?闆嗛敭鍊硷紝
聽聽聽聽聽濡?聽聽 default-character-set = utf8
聽聽聽聽聽 character_set_server =聽 utf8
聽聽聽 聽淇?敼瀹屽悗锛岄噸鍚痬ysql鐨勬湇鍔?/span>
(2) 杩樻湁涓?绉嶄慨鏀瑰瓧绗﹂泦鐨勬柟娉曪紝灏辨槸浣跨敤mysql鐨勫懡浠?/span>
聽聽 聽 mysql> SET character_set_client = utf8 ;
聽聽聽聽 mysql> SET character_set_connection = utf8 ;
聽聽聽聽 mysql> SET character_set_database = utf8 ;
聽聽聽聽 mysql> SET character_set_results = utf8 ;
聽聽聽聽 mysql> SET character_set_server = utf8 ;
聽聽聽聽 mysql> SET collation_connection = utf8 ;
聽聽聽聽 mysql> SET collation_database = utf8 ;
聽聽聽聽 mysql> SET collation_server = utf8 ;
聽
聽聽聽 璁剧疆浜嗚〃鐨勯粯璁ゅ瓧绗﹂泦涓簎tf8骞朵笖閫氳繃UTF-8缂栫爜鍙戦?佹煡璇?紝瀛樺叆鏁版嵁搴撶殑浠嶇劧鏄?贡鐮併?傞偅connection杩炴帴灞備笂鍙?兘鍑轰簡闂??銆傝В鍐虫柟娉曟槸鍦ㄥ彂閫佹煡璇㈠墠鎵ц?涓?涓嬩笅闈㈣繖鍙ワ細 SET NAMES 'utf8';瀹冪浉褰撲簬涓嬮潰鐨勪笁鍙ユ寚浠わ細
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;