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')
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')
转载于:https://www.cnblogs.com/wqlys/p/4961674.html