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