HaHa_Sir: 不知道为啥，回复您的评论看不到. .

HaHa_Sir: 一二三四五六进行排序： 示例代码如下： [code=sql] SELECT * FROM ( SELECT '一' AS n FROM dual UNION ALL SELECT '二' AS n FROM dual UNION ALL SELECT '三' AS n FROM dual UNION ALL SELECT '四' AS n FROM dual UNION ALL SELECT '五' AS n FROM dual UNION ALL SELECT '六' AS n FROM dual UNION ALL SELECT '七' AS n FROM dual UNION ALL SELECT '八' AS n FROM dual UNION ALL SELECT '九' AS n FROM dual UNION ALL SELECT '十' AS n FROM dual ) tab --ORDER BY tab.n ORDER BY TRANSLATE(tab.n,'零一二三四五六七八九','0123456789') [/code]

HaHa_Sir: 您好，可以使用 “TRANSLATE” 函数 实现排序 。 实例代码如下： [code=sql] SELECT * FROM ( SELECT '一' AS n FROM dual UNION ALL SELECT '二' AS n FROM dual UNION ALL SELECT '三' AS n FROM dual UNION ALL SELECT '四' AS n FROM dual UNION ALL SELECT '五' AS n FROM dual UNION ALL SELECT '六' AS n FROM dual UNION ALL SELECT '七' AS n FROM dual UNION ALL SELECT '八' AS n FROM dual UNION ALL SELECT '九' AS n FROM dual UNION ALL SELECT '十' AS n FROM dual ) tab --ORDER BY tab.n ORDER BY TRANSLATE(tab.n,'零一二三四五六七八九','0123456789') [/code] 参考资料： https://www.cnblogs.com/lgx5/p/16684814.html

周子斐: 推荐你使用我的上传组件，我开放到github上了 [code=java] com.zhouzifei simpleFS v1.0.4.RELEASES [/code] 开源地址为https://github.com/shengdingbox/simpleFS，可以一键上传

竹肖臣: 那要是一二三四五六进行排序呢