原生的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