真正能解決mysql5.5中文亂碼方法

鎴戞煡杩囧強娴嬭瘯杩囧绉嶈В鍐充貢鐮佺殑鏂規硶锛屽崄鏈夊叓涔濅笉鍏ㄩ潰瀵艱嚧涓嶆垚鍔燂紝涓嬮潰鎾ゅ簳瑙ｅ喅杩欎竴闂銆?

瑙ｅ喅涔辯爜鏈€濂界殑鏂規硶鏄湪椤圭洰璁捐涔嬪垵锛岀粺涓€鎵€鏈夌殑瀛楃闆嗭紝渚嬪椤甸潰銆乺equest瀵矽薄浠ュ強鏁版嵁搴撶瓑绛夈€偮?

涓€銆?鍑犵甯歌鐨勪貢鐮佺幇璞★細聽

1銆侀〉闈貢鐮伮? 聽 聽 鍗曠函鐨勯〉闈貢鐮佹槸寰堝ソ瑙ｅ喅鐨勶紝鍙淇敼澶撮儴閫傚悎鐨勫瓧绗﹂泦鍗沖彲锛屽鏋滈〉闈腑鏂囨樉绀轟貢鐮侊紝浣犲彲浠ユ妸瀛楃闆嗕慨鏀逛負锛歡b2312鎴杇bk銆偮?

2銆侀〉闈箣闂翠紶閫掔殑鍙傛暟鏄貢鐮伮? 聽 聽椤甸潰涔嬮棿浼犻€掑弬鏁闆嚭鐜扮殑涔辯爜锛屽氨瑕佽В鍐抽〉闈㈢紪鐮佸拰requset鐨勫瓧绗﹂泦闂锛屽湪鍙傛暟浼犺繘浼犲嚭鏃堕噸鏂拌缃浉搴旂殑瀛楃闆嗐€傛瘮濡傦細request.setCharacterEncoding("UTF-8");聽

3銆佹暟鎹簱涔辯爜锛堜笅闈㈣缁嗕粙缁嶏級聽

浜屻€佹暟鎹簱涔辯爜瑙ｅ喅鏂規硶锛圡ysql锛壜?

聽 聽椤甸潰鍜岄〉闈紶鍊奸兘娌℃湁闂锛岀粨鏋滃彂鐜闆瓨鍌ㄥ湪鏁版嵁搴撲腑鐨勬暟鎹嚭鐜頒簡涔辯爜锛屽垯闂鏄嚭鐜闆湪鏁版嵁搴撶殑缂栫爜闂銆偮? 聽 聽涓嬮潰鎴戝凡MySql鏁版嵁搴撲負渚嬭鏄庤В鍐蟲柟娉曪細聽

聽 聽 濡傛灉浣犲畨瑁呮暟鎹簱鐨勬椂鍊欏瓧绗﹂泦浣跨敤鐨勯粯璁ら€夐」锛歭atin1聽

聽 聽 DOS鍛戒護涓嬭繘鍏ユ暟鎹簱show 涓€涓嬪瓧绗﹂泦锛堝懡浠わ細show variables like"%char%"; 锛夋樉绀哄涓嬶細

1.+--------------------------+---------------+ 聽聽

2.| Variable_name 聽 聽 聽 聽 聽 聽| Value 聽 聽 聽 聽 | 聽聽

3.+--------------------------+---------------+ 聽聽

4.| character_set_client 聽 聽 | latin1 聽 聽 聽 聽| 聽聽

5.| character_set_connection | latin1 聽 聽 聽 聽| 聽聽

6.| character_set_database 聽 | latin1 聽 聽 聽 聽| 聽聽

7.| character_set_filesystem | binary 聽 聽 聽 聽| 聽聽

8.| character_set_results 聽 聽| latin1 聽 聽 聽 聽| 聽聽

9.| character_set_server 聽 聽 | latin1 聽 聽 聽 聽| 聽聽

10.| character_set_system 聽 聽 | utf8 聽 聽 聽 聽 聽| 聽聽

11.+--------------------------+---------------+ 聽

1銆佷慨鏀規暟鎹簱榛樿瀛楃闆嗭細聽

鎵撳紑C:\Program Files\MySQL\MySQL Server 5.0閲岄潰鐨刴y.ini鏂囦歡鎵懼埌杩欐鏂囧瓧锛毬?

寮曠敤

# The default character set that will be used when a new schema or table is聽

# created and no character set is defined聽

default-character-set=latin1聽

鎶奷efault-character-set=latin1鏀逛負default-character-set=gbk聽

杩欐椂鍊檚how 涓€涓嬪瓧绗﹂泦锛堥噸鏂闆惎鍔╩ysql鏈嶅姟 锛屽懡浠わ細show variables like"%char%"; 锛夋樉绀哄涓嬶細聽

Java浠ｇ爜 聽

1.+--------------------------+---------------+ 聽聽

2.| Variable_name 聽 聽 聽 聽 聽 聽| Value 聽 聽 聽 聽 | 聽聽

3.+--------------------------+---------------+ 聽聽

4.| character_set_client 聽 聽 | latin1 聽 聽 聽 聽| 聽聽

5.| character_set_connection | latin1 聽 聽 聽 聽| 聽聽

6.| character_set_database 聽 | gbk 聽 聽 聽 聽 聽 | 聽聽

7.| character_set_filesystem | binary 聽 聽 聽 聽| 聽聽

8.| character_set_results 聽 聽| latin1 聽 聽 聽 聽| 聽聽

9.| character_set_server 聽 聽 | latin1 聽 聽 聽 聽| 聽聽

10.| character_set_system 聽 聽 | utf8 聽 聽 聽 聽 聽| 聽聽

11.+--------------------------+---------------+ 聽

+--------------------------+---------------+

| Variable_name 聽 聽 聽 聽 聽 聽| Value 聽 聽 聽 聽 |

+--------------------------+---------------+

| character_set_client 聽 聽 | latin1 聽 聽 聽 聽|

| character_set_connection | latin1 聽 聽 聽 聽|

| character_set_database 聽 | gbk 聽 聽 聽 聽 聽 |

| character_set_filesystem | binary 聽 聽 聽 聽|

| character_set_results 聽 聽| latin1 聽 聽 聽 聽|

| character_set_server 聽 聽 | latin1 聽 聽 聽 聽|

| character_set_system 聽 聽 | utf8 聽 聽 聽 聽 聽|

+--------------------------+---------------+

2銆佸鏋滀綘鏄鍏ョ殑鏁版嵁搴擄紝闇€瑕佸my.ini鍋氬涓嬩慨鏀規壘鍒奧?

寮曠敤

[client]聽

port=3306聽

[mysql]聽

default-character-set=latin1聽

鎶?default-character-set=latin1鏀逛負default-character-set=gbk聽

寮曠敤

# SERVER SECTION聽

# ----------------------------------------------------------------------聽

#聽

# The following options will be read by the MySQL Server. Make sure that聽

# you have installed the server correctly (see above) so it reads this聽

# file.聽

#聽

[mysqld]聽

鎵懼埌聽

澧炲姞default-character-set=gbk聽

鐒跺悗鍦ㄨ缃竴涓嬩綘瀵煎叆鐨勬暟鎹簱瀛楃闆嗗嵆鍙細聽

鍛戒護:alter database 聽浣犵殑鏁版嵁搴撳悕 charset = gbk;聽

閲嶆柊鍚姩mysql鏈嶅姟,show 涓€涓嬪瓧绗﹂泦锛堬紝鍛戒護锛歴how variables like"%char%"; 锛夋樉绀哄涓嬶細聽

Java浠ｇ爜 聽

1.+--------------------------+---------------+ 聽聽

2.| Variable_name 聽 聽 聽 聽 聽 聽| Value 聽 聽 聽 聽 | 聽聽

3.+--------------------------+---------------+ 聽聽

4.| character_set_client 聽 聽 | gbk 聽 聽 聽 聽 聽 | 聽聽

5.| character_set_connection | gbk 聽 聽 聽 聽 聽 | 聽聽

6.| character_set_database 聽 | gbk 聽 聽 聽 聽 聽 | 聽聽

7.| character_set_filesystem | binary 聽 聽 聽 聽| 聽聽

8.| character_set_results 聽 聽| gbk 聽 聽 聽 聽 聽 | 聽聽

9.| character_set_server 聽 聽 | gbk 聽 聽 聽 聽 聽 | 聽聽

10.| character_set_system 聽 聽 | utf8 聽 聽 聽 聽 聽| 聽聽

11.+--------------------------+---------------+ 聽

+--------------------------+---------------+

| Variable_name 聽 聽 聽 聽 聽 聽| Value 聽 聽 聽 聽 |

+--------------------------+---------------+

| character_set_client 聽 聽 | gbk 聽 聽 聽 聽 聽 |

| character_set_connection | gbk 聽 聽 聽 聽 聽 |

| character_set_database 聽 | gbk 聽 聽 聽 聽 聽 |

| character_set_filesystem | binary 聽 聽 聽 聽|

| character_set_results 聽 聽| gbk 聽 聽 聽 聽 聽 |

| character_set_server 聽 聽 | gbk 聽 聽 聽 聽 聽 |

| character_set_system 聽 聽 | utf8 聽 聽 聽 聽 聽|

+--------------------------+---------------+

濡傛灉浣犺鍒闆涓婂唴瀹癸紝鏁版嵁搴撳瓧绗﹂泦闂宸茶В鍐熾€偮? 濡傛灉浣犵殑椤圭洰杩樻湁瀛楃闆嗛棶棰橈紝閭ｅ氨闇€瑕佹煡鐪嬩竴涓嬫槸鍚︽槸鍏朵粬鍥犵礌瀵艱嚧鐨勪貢鐮佷簡锛屾瘮濡傛垜寮€绡囨椂鎻愬埌鐨勯棶棰樸€偮?

濡傛灉鎵句笉鍒癿y.ini鏂囦歡 璇瘋嚜宸卞垱寤轟竴涓€?