實踐過程如下:
1? 在DOS中執(zhí)行 mysql -h localhost -u root -p? 進入mysql的DOS操作環(huán)境,
2? 執(zhí)行?show variables like 'character_set_%'; 顯示出了我本機mysql的有關(guān)字符?編碼的設(shè)置,結(jié)果如下:
+--------------------------+-----------------------------+
| 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\ |
+--------------------------+-----------------------------+

看到了,這就是亂碼的原因了,現(xiàn)在我統(tǒng)一采用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

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

4 把原來的數(shù)據(jù)全清楚.重新執(zhí)行腳本導出數(shù)據(jù)就一切搞定了.

5? 把開源玩到底!