我把数据库里面的数据通过ODBC配置的数据源,在XLS文件中直接把数据导出,
可是导出来的全是乱码???
请大家指教!!
当前数据库编码如下:
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\ |
服务器的编码是:latin1要修改服务器的编码该怎么办
可是导出来的全是乱码???
请大家指教!!
当前数据库编码如下:
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\ |
服务器的编码是:latin1要修改服务器的编码该怎么办
看一下已经结贴的。又好多类似的问题。
是 不是很麻烦那!