我先将Excel数据保存成为“文本文件(制表符分割)”,然后使用cmd命令行操作Mysql数据库,使用load data local infile 'D:\data.txt' into table excel fields terminated by '\t'; 语句将data.txt数据导入excel表,但是中文导入后有乱码,我把excel表编码方式改成UTF8和GB2312和GBK都不行,都是乱码,但是我在cmd中使用 select * from excel 查询出的数据又能正常显示了,没有乱码了,在数据库中查看确实是乱码。请高手指教!!
show variables like 'char%'然后调整一下,再load data
MySQL 中文显示乱码
mysql> show variables like 'char%';
+--------------------------+----------------------------------------------------
-----+
| 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
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
我全部修改成utf8了,但是乱码依旧