数据库中文排序
mysql
按拼音
ORDER BY convert(district1 USING gbk)
Oracle
按拼音
ORDER BY nlssort(NAME, 'NLS_SORT=SCHINESE_PINYIN_M')
按部首顺序
ORDER BY nlssort(NAME, 'NLS_SORT=SCHINESE_RADICAL_M')
按笔画书序
ORDER BY nlssort(NAME, 'NLS_SORT=SCHINESE_STROKE_M')