原生的sql写法：

  SELECT *

        FROM br_esf_village_building

WHERE 1

ORDER BY CONVERT(  `buildingName`

USING gbk )

COLLATE gbk_chinese_ci ASC

tp框架的写法：

 $data = $this->where($where)->field($field)->order('CONVERT( `buildingName` USING gbk )COLLATE gbk_chinese_ci ASC')->select();

本文转自 liang3391 51CTO博客，原文链接:http://blog.51cto.com/liang3391/1871232