mysql 5.0以上版本,为GB2312
把mysql里的数据库通过ODBC配置数据源连接到excel
从excel里导出的中文字是??? 的乱码!
请帮忙分析解决,谢谢了!
mysql> show variables like '%char%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gb2312
|
| character_set_connection | gb2312
|
| character_set_database | gb2312
|
| character_set_filesystem | binary
|
| character_set_results | gb2312
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |这是当前数据库的编码!!
把mysql里的数据库通过ODBC配置数据源连接到excel
从excel里导出的中文字是??? 的乱码!
请帮忙分析解决,谢谢了!
mysql> show variables like '%char%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gb2312
|
| character_set_connection | gb2312
|
| character_set_database | gb2312
|
| character_set_filesystem | binary
|
| character_set_results | gb2312
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |这是当前数据库的编码!!
而且还有个UTF8的看这个帖子:http://topic.csdn.net/u/20070925/13/ba345dba-5525-4a46-a5e9-d54eb00af176.html