Oracle,MySql和PostGreSql对中文字段按拼音排序

1.oracle
SELECT * FROM TABLE ORDER BY NLSSORT(chineseColumnName,'NLS_SORT = SCHINESE_PINYIN_M');
2.mysql  
--字符编码是utf8_general_ci
SELECT * FROM TABLE ORDER BY CONVERT(chineseColumnName USING gbk) COLLATE gbk_chinese_ci ASC;
--字符编码是latin1_swedish_ci
SELECT * FROM TABLE ORDER BY BIRARY(chineseColumnName) ASC ;
3.postgresql
SELECT * FROM TABLE ORDER BY CONVERT_TO("chineseColumnName" ,'GBK');