我从mysql select 数据显示到表中也不乱码,但JTable里的单元格的数据update到数据库时,中文变???了...我更新代码:
try{
sql = new String(sql.getBytes(),"utf-8");
}catch(Exception ex)
{
}
//dataOption.exec("set names utf8");
//System.out.println(sql);
dataOption.exec(sql);
try{
sql = new String(sql.getBytes(),"utf-8");
}catch(Exception ex)
{
}
//dataOption.exec("set names utf8");
//System.out.println(sql);
dataOption.exec(sql);
show variables like '%charset%'
回二楼:show variables like '%character_set%' 结果是
character_set_client:utf8
character_set_connection:utf8
character_set_database:latin1:latin1
character_set_filesystem:binary
character_set_results:utf8
character_set_server:latin1
character_set_system:utf8
character_sets_dir:D:\Program Files\wamp\bin\mysql\mysql5.1.33\share\charsets\
这就是我说的JDBC的连接 需要制定编码