首先检查一下你数据库的字符集设置好了没有, mysql> show variables like "%char%"; +--------------------------+---------------------------------------------------+ | Variable_name | Value
my.ini # 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 设置你的字符
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
设置你的字符