實(shí)踐過(guò)程如下: 1 在DOS中執行 mysql -h localhost -u root -p 進(jìn)入mysql的DOS操作環(huán)境,
2 執行 show variables like 'character_set_%'; 顯示出了我本機mysql的有關(guān)字符 編碼的設置,結果如下:
+--------------------------+-----------------------------+
| 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 把原來(lái)的數據全清楚.重新執行腳本導出數據就一切搞定了.
5 把開(kāi)源玩到底!