mysql +java中文乱码

第一种情况：mysql能插入中文，但是java查询、更新处理中文乱码

1，找到Mysql安装目录下的 my.ini文件，用记事本打开：如果你的文件某部分与下面的部分内容一致
 
[mysql]
 
default-character-set=latin1
 
--------------------------------------------------------------------------------------------------
 
[mysqld]
 
# The TCP/IP Port the MySQL Server will listen on
port=3306 
 
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
 
#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
 
# 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数据库的中文处理：

str=new String(str.getBytes("gb2312"),"ISO-8859-1");

从mysql数据库查询出来中文处理：

str=new String(rs.getString(2).getBytes("ISO-8859-1"),"gb2312");

第二种情况，mysql不能插入中文，而且java查询、更新数据库出现中文乱码

参考：http://developer.51cto.com/art/200906/130425.htm

1，设置Mysql的编码格式（注意是在创建数据库之前就要设置）
 
找到Mysql安装目录下的 myini文件，用记事本打开，找到以下两句改为以下的值： 
 
[mysql]
 
default-character-set=gb2312
 
--------------------------------------------------------------------------------------------------
 
[mysqld]
 
# The TCP/IP Port the MySQL Server will listen on
port=3306 
 
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
 
#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
 
# 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=utf8
2,打开mysql，在mysql那里查询一下，应该会是以下的结果。

 show variables like 'character%';  

+--------------------------+--------------------------+ 

| Variable_name            | Value                    |  

+--------------------------+--------------------------+ 

| character_set_client     | gb2312                   |  

| character_set_connection | gb2312                   |  

| character_set_database   | utf8                     |  

| character_set_filesystem | binary                   |  

| character_set_results    | gb2312                   |  

| character_set_server     | utf8                     |  

| character_set_system     | utf8               |  

+--------------------------+--------------------------+ 

3，然后在MYSQL插入中文应该没有问题了吧。


4，在java查询、插入、修改中文数据的时候进行这样的处理：
String str=new String(t[3].getText().getBytes("GBK"),"gb2312");

至于为什么是“GBK”我也还没有弄清楚，反正其他的不行。。。