<!-- 数据库中文三种排序 -->
<sql id="chineseSortingToUsrDisplayBil">
<choose>
<when test="_databaseId == 'ORACLE'">
ORDER BY nlssort(itm_title, 'NLS_SORT=SCHINESE_PINYIN_M') asc
</when>
<when test="_databaseId == 'SQLSERVER'">
ORDER BY itm_title collate Chinese_PRC_CS_AS_KS_WS asc
</when>
<otherwise>
ORDER BY CONVERT(itm_title using gbk) asc
</otherwise>
</choose>
</sql>