解決亂碼最好的方法是在項目設(shè)計之初，統(tǒng)一所有的字符集，例如頁面、request對象以及數(shù)據(jù)庫等等。

一、 幾種常見的亂碼現(xiàn)象：
1、頁面亂碼
??? 單純的頁面亂碼是很好解決的，只要修改頭部適合的字符集即可，如果頁面中文顯示亂碼，你可以把字符集修改為：gb2312或gbk。

2、頁面之間傳遞的參數(shù)是亂碼
?? 頁面之間傳遞參數(shù)出現(xiàn)的亂碼，就要解決頁面編碼和requset的字符集問題，在參數(shù)傳進傳出時重新設(shè)置相應(yīng)的字符集。比如：request.setCharacterEncoding("UTF-8");

3、數(shù)據(jù)庫亂碼（下面詳細介紹）

二、數(shù)據(jù)庫亂碼解決方法（Mysql）

?? 頁面和頁面?zhèn)髦刀紱]有問題，結(jié)果發(fā)現(xiàn)存儲在數(shù)據(jù)庫中的數(shù)據(jù)出現(xiàn)了亂碼，則問題是出現(xiàn)在數(shù)據(jù)庫的編碼問題。
?? 下面我已MySql數(shù)據(jù)庫為例說明解決方法：

??? 如果你安裝數(shù)據(jù)庫的時候字符集使用的默認選項：latin1
??? DOS命令下進入數(shù)據(jù)庫show 一下字符集（命令：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???|?latin1????????| ??
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   | latin1        |
| character_set_filesystem | binary        |
| character_set_results    | latin1        |
| character_set_server     | latin1        |
| character_set_system     | utf8          |
+--------------------------+---------------+

  

1、修改數(shù)據(jù)庫默認字符集：
打開C:\Program Files\MySQL\MySQL Server 5.0里面的my.ini文件找到這段文字：

把default-character-set=latin1改為default-character-set=gbk

這時候show 一下字符集（重新啟動mysql服務(wù) ，命令：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、如果你是導入的數(shù)據(jù)庫，需要對my.ini做如下修改找到

把 default-character-set=latin1改為default-character-set=gbk

找到
增加default-character-set=gbk

然后在設(shè)置一下你導入的數(shù)據(jù)庫字符集即可：

命令:alter database? 你的數(shù)據(jù)庫名 charset = gbk;

重新啟動mysql服務(wù),show 一下字符集（，命令：show 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          |
+--------------------------+---------------+

  

如果你見到如上內(nèi)容，數(shù)據(jù)庫字符集問題已解決。
如果你的項目還有字符集問題，那就需要查看一下是否是其他因素導致的亂碼了，比如我開篇時提到的問題。

MySql數(shù)據(jù)庫中文亂碼解決方法