def sqlString=" select b.id,b.name from building b where b.cbd_id=:cbd order by hex(CONVERT( b.name USING gbk ) ) asc"
首先用CONVERT转换编码,然后hex
HEX()函数将一个字符串或数字转换为十六进制格式的字符串:
http://www.hardwork.cn/?p=96 关于hex和unhex函数
def sqlString=" select b.id,b.name from building b where b.cbd_id=:cbd order by hex(CONVERT( b.name USING gbk ) ) asc"