mysql中文查询

Question

MYSQL的中文问题。找不到中文记录～～

Answer 1

首先确定你数据库的字符集是不是UTF-8
mysql> show variables like "%char%";
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | utf8                     |
| character_set_connection | utf8                     |
| character_set_database   | utf8                     |
| character_set_filesystem | binary                   |
| character_set_results    | utf8                     |
| character_set_server     | utf8                     |
| character_set_system     | utf8                     |
| character_sets_dir       | C:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.03 sec)然后你将这句转换后再打印出来看看有没有乱码
String sql1 = "SELECT * FROM tbtest WHERE username ='留学生'";
sql1=new String(sql1.getBytes("ISO-8859-1"),"UTF-8");
System.out.println(sql1);没有乱码后再执行查询,你试试看行不行?