java做mysql的模糊查询就输入中文的时候没有返回结果,输入字母数字都有结果,数据库的编码都是utf—8的,sql语句
String sql = "select name,typeName,address,remark from t_hotel where CONCAT(name,typeName,address,remark) " +
"like BINARY '%"+ pararmContent + "%' limit " + start + "," + limit;
String sql = "select name,typeName,address,remark from t_hotel where CONCAT(name,typeName,address,remark) " +
"like BINARY '%"+ pararmContent + "%' limit " + start + "," + limit;









