Java取Mysql数据中文乱码问题

问题

eclipse环境为UTF-8
mysql环境为

+————————–+—————————-+
| Variable_name | Value |
+————————–+—————————-+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+————————–+—————————-+

取数据代码：

String sql = "select * from " + tablename + " limit 100";
ResultSet rs = sm.executeQuery(sql);
String field = rs.getString(fieldname);

这样取出来之后中文变成乱码

解决

java代码改为

String sql = "select * from " + tablename + " limit 100";
ResultSet rs = sm.executeQuery(sql);
String field = new String(rs.getBytes(fieldname),"UFT-8");