mysql5+hibernate中文排序

SQL:select *from tableName order by (colName using gbk);

 

使用HIBERNATE的createSQLQuery查询取值：

 

List<entityName> list;

query=session.createSQLQuery(sql).addEntity(entityName);

list=query.list();

for(entityName entity:list){

       System.out.println(entity);

}