--鏇存敼瀛楃闆?
SET character_set_client = utf-8 ;
SET character_set_connection = utf-8 ;
SET character_set_database = utf-8 ;
SET character_set_results = utf-8 ;
SET character_set_server = utf-8 ;
SET collation_connection = utf8 ;
SET collation_database = utf8 ;
SET collation_server = utf8 ;
MySQL鐨勫瓧絎﹂泦鏀寔(Character Set Support)鏈変袱涓柟闈細瀛楃闆?Character set)鍜屾帓搴忔柟寮?Collation)銆傚浜庡瓧絎﹂泦鐨勬敮鎸佺粏鍖栧埌鍥涗釜灞傛:
鏈嶅姟鍣?server)錛屾暟鎹簱(database)錛屾暟鎹〃(table)鍜岃繛鎺?connection)銆?
1.MySQL榛樿瀛楃闆?MySQL瀵逛簬瀛楃闆嗙殑鎸囧畾鍙互緇嗗寲鍒頒竴涓暟鎹簱錛屼竴寮犺〃錛屼竴鍒?浼犵粺鐨勭▼搴忓湪鍒涘緩鏁版嵁搴撳拰鏁版嵁琛ㄦ椂騫舵病鏈変嬌鐢ㄩ偅涔堝鏉傜殑閰嶇疆錛屽畠浠敤鐨勬槸榛樿鐨勯厤緗? (1)緙栬瘧MySQL 鏃訛紝鎸囧畾浜嗕竴涓粯璁ょ殑瀛楃闆嗭紝榪欎釜瀛楃闆嗘槸 latin1錛?2)瀹夎MySQL 鏃訛紝鍙互鍦ㄩ厤緗枃浠?(my.ini) 涓寚瀹氫竴涓粯璁ょ殑鐨勫瓧絎﹂泦錛屽鏋滄病鎸囧畾錛岃繖涓肩戶鎵胯嚜緙栬瘧鏃舵寚瀹氱殑錛?3)鍚姩mysqld 鏃訛紝鍙互鍦ㄥ懡浠よ鍙傛暟涓寚瀹氫竴涓粯璁ょ殑鐨勫瓧絎﹂泦錛屽鏋滄病鎸囧畾錛岃繖涓肩戶鎵胯嚜閰嶇疆鏂囦歡涓殑閰嶇疆,姝ゆ椂 character_set_server 琚瀹氫負榪欎釜榛樿鐨勫瓧絎﹂泦錛?4)褰撳垱寤轟竴涓柊鐨勬暟鎹簱鏃訛紝闄ら潪鏄庣‘鎸囧畾錛岃繖涓暟鎹簱鐨勫瓧絎﹂泦琚己鐪佽瀹氫負character_set_server錛?5)褰撻夊畾浜嗕竴涓暟鎹簱鏃訛紝character_set_database 琚瀹氫負榪欎釜鏁版嵁搴撻粯璁ょ殑瀛楃闆嗭紱(6)鍦ㄨ繖涓暟鎹簱閲屽垱寤轟竴寮犺〃鏃訛紝琛ㄩ粯璁ょ殑瀛楃闆嗚璁懼畾涓?character_set_database錛屼篃灝辨槸榪欎釜鏁版嵁搴撻粯璁ょ殑瀛楃闆嗭紱(7)褰撳湪琛ㄥ唴璁劇疆涓鏍忔椂錛岄櫎闈炴槑紜寚瀹氾紝鍚﹀垯姝ゆ爮緙虹渷鐨勫瓧絎﹂泦灝辨槸琛ㄩ粯璁ょ殑瀛楃闆嗭紱濡傛灉浠涔堝湴鏂歸兘涓嶄慨鏀癸紝閭ｄ箞鎵鏈夌殑鏁版嵁搴撶殑鎵鏈夎〃鐨勬墍鏈夋爮浣嶇殑閮界敤 latin1 瀛樺偍錛屼笉榪囨垜浠鏋滃畨瑁?MySQL錛屼竴鑸兘浼氶夋嫨澶氳璦鏀寔錛屼篃灝辨槸璇達紝瀹夎紼嬪簭浼氳嚜鍔ㄥ湪閰嶇疆鏂囦歡涓妸 default_character_set 璁劇疆涓?UTF-8錛岃繖淇濊瘉浜嗙己鐪佹儏鍐典笅錛屾墍鏈夌殑鏁版嵁搴撶殑鎵鏈夎〃鐨勬墍鏈夋爮浣嶇殑閮界敤 UTF-8 瀛樺偍銆?
2.鏌ョ湅榛樿瀛楃闆?榛樿鎯呭喌涓嬶紝mysql鐨勫瓧絎﹂泦鏄痩atin1(ISO_8859_1)閫氬父錛屾煡鐪嬬郴緇熺殑瀛楃闆嗗拰鎺掑簭鏂瑰紡鐨勮瀹氬彲浠ラ氳繃涓嬮潰鐨勪袱鏉″懡浠わ細
mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:"mysql-5.0.37"share"charsets" |
+--------------------------+---------------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3.淇敼榛樿瀛楃闆?
(1) 鏈綆鍗曠殑淇敼鏂規硶錛屽氨鏄慨鏀筸ysql鐨刴y.ini鏂囦歡涓殑瀛楃闆嗛敭鍊鹼紝
濡?nbsp; default-character-set = utf8
character_set_server = utf8
淇敼瀹屽悗錛岄噸鍚痬ysql鐨勬湇鍔★紝service mysql restart
浣跨敤 mysql> SHOW VARIABLES LIKE 'character%';鏌ョ湅錛屽彂鐜版暟鎹簱緙栫爜鍧囧凡鏀規垚utf8
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:"mysql-5.0.37"share"charsets" |
+--------------------------+---------------------------------+
(2) 榪樻湁涓縐嶄慨鏀瑰瓧絎﹂泦鐨勬柟娉曪紝灝辨槸浣跨敤mysql鐨勫懡浠?
SET character_set_client = utf8 ;
SET character_set_connection = utf8 ;
SET character_set_database = utf8 ;
SET character_set_results = utf8 ;
SET character_set_server = utf8 ;
mysql> SET collation_connection = utf8 ;
mysql> SET collation_database = utf8 ;
mysql> SET collation_server = utf8 ;
涓鑸氨綆楄緗簡琛ㄧ殑榛樿瀛楃闆嗕負utf8騫朵笖閫氳繃UTF-8緙栫爜鍙戦佹煡璇紝浣犱細鍙戠幇瀛樺叆鏁版嵁搴撶殑浠嶇劧鏄貢鐮併傞棶棰樺氨鍑哄湪榪欎釜connection榪炴帴灞備笂銆傝В鍐蟲柟娉曟槸鍦ㄥ彂閫佹煡璇㈠墠鎵ц涓涓嬩笅闈㈣繖鍙ワ細
SET NAMES 'utf8';
瀹冪浉褰撲簬涓嬮潰鐨勪笁鍙ユ寚浠わ細
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
涓嶇煡閬撲粈涔堝師鍥?鎴戝湪鑷繁鏈哄櫒涓婃妸涓婅堪涓変釜瀛楃闆嗛兘璁劇疆鎴恥tf8鍚?鏌ヨ涓枃緇撴灉榪樻槸涔辯爜,鍙湁鎶奵haracter_set_results璁劇疆鎴怗BK涔嬪悗鎵嶈兘浠庡懡浠よ姝ｅ父鏄劇ず涓枃.
set character_set_results=GBK;
]]>