我用ODBC连也乱码,请问那里设置GBK编码方式
解决方案 »
- count(*)出現錯誤 #1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1 ?
- 帮我看下这个sql语句怎么写且效率高
- MySQL 一个BETWEEN查询
- mysql链接不上报错
- *******各位大侠救命啊,关于Mysql5.0的问题,搞了一天了,崩溃啊~~~~~~~~~~~~~
- 关于多表查询!!!
- java 操作Mysql问题……
- 高难度问题:java mysql海量数据复制 一致性问题
- 数据库mysql,后端node做的报表统计问题
- MYSQL与HBASE选型的问题
- 重装了MYSQL后如何把以前的数据库加入到新的MYSQL里,使旧的数据库表也能访问。
- 怎么把一个从windows下拷贝到linux下的文件里的……^M字符一下字全部去掉啊?
mysql> show variables like "%char%";
+--------------------------+---------------------------------------------------+
| Variable_name | Value
+--------------------------+---------------------------------------------------+
| character_set_client | gbk
|
| character_set_connection | gbk
|
| character_set_database | gbk
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | gbk
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+------------------------------------------------------+
8 rows in set (0.16 sec)用JDBC连接的时候应该使用:"jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK"
mysql> show variables like "%char%";
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
7 rows in set (0.00 sec)
请问怎么把他们设置成GBK啊!我是FC4的操作系统,就是那个免费版的red hat linux社区的。/usr/local/mysql/share/mysql/charsets/目录下面没有见到有GBK的语言文件。还请高手指点迷津谢谢。
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
设置你的字符