mysql中文查询得不到结果

Question

[size=large][/size][size=large][/size]//String sql = "select * from file where name LIKE BINARY '%"+name+"%'";
String sql = "SELECT * FROM file WHERE locate(name,\'"+name+"\') > 0;" ;
//String sql = "select path from file where name like '%"+name+"%'";
//String sql= "SELECT * FROM file WHERE locate(name,'"+name+"') > 0";
//String sql = "select path from file where name LIKE '%"+name+"%'";
//String sql = "select path from file where name LIKE ?";
// SELECT * FROM table_name WHERE field_name LIKE BINARY '%了%';
PreparedStatement ps = con.prepareStatement(sql);
//ps.setString(1, "%"+name+"%");

ResultSet rs = ps.executeQuery();
System.out.println(sql);

以上sql语句我都试过，都得不到值；可是控制台打印出来的sql语句，我粘贴到cmd上运行，可以得到结果；
运行 show variables like 'character_set_%';显示
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--------------------------+--------+
都搞一天了，真不知道该怎么办了

Answer 1

那就是编码问题了 整个项目全部统一成utf-8
最好写个过滤器吧