實踐過程如下:
1? 在DOS中執行 mysql -h localhost -u root -p? 進入mysql的DOS操作環境,
2? 執行?show variables like 'character_set_%'; 顯示出了我本機mysql的有關字符?編碼的設置,結果如下:
+--------------------------+-----------------------------+
| Variable_name??????????? | Value?????????????????????? |
+--------------------------+-----------------------------+
| character_set_client???? | latin1????????????????????? |
| character_set_connection | latin1????????????????????? |
| character_set_database?? | gbk???????????????????????? |
| character_set_results??? | latin1????????????????????? |
| character_set_server???? | gbk???????????????????????? |
| character_set_system???? | utf8??????????????????????? |
| character_sets_dir?????? | E:\mysql513\share\charsets\ |
+--------------------------+-----------------------------+

看到了,這就是亂碼的原因了,現在我統一采用UTF-8編碼,操作如下:
3
? 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

執行后后,你需要把c:/winNt/my.ini添加這"default-character-set=utf8"這行.

4 把原來的數據全清楚.重新執行腳本導出數據就一切搞定了.

5? 把開源玩到底!