1.在mysql的配置文件my.ini或者my-default.ini中添加如下字段
[client]
default-character-set=gbk
[mysql]
default-character-set=gbk
[mysqld]
character-set-server=gbk
collation-server=gbk_chinese_ci
init_connect='SET NAMES gbk'
2.用命令行登陆mysql,查看字符编码:
mysql> show variables like 'character%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | F:\Program Files\mysql\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
将除filesystem和system之外的行都置为gbk:
mysql> set character_set_database=gbk;
Query OK, 0 rows affected (0.00 sec)
3.在eclipse的Preferences-General-Workspace里改成GBK
4.在项目上点右键-Properties-Resource改成GBK
5.数据库和表在创建时都要选择好编码格式。
6.网页和xml等编码格式改为gbk
例:
例:
7.在数据库连接字符串后面添加:?useUnicode=true&characterEncoding=GBK
注意如果是在xml文件里配置数据库,则&要改成&
最终解决的方案