如何使用SQL Order By语句对不区分大小写的结果进行排序? [英] How to use SQL Order By statement to sort results case insensitive?

问题描述

我有一个SQLite数据库，试图按字母顺序排序.问题是，SQLite似乎在排序过程中没有考虑A = a，因此我得到如下结果:

I have a SQLite database that I am trying to sort by Alphabetical order. The problem is, SQLite doesn't seem to consider A=a during sorting, thus I get results like this:

A 乙 C Ť 一种 b C g

A B C T a b c g

我想得到:

A 一种 b 乙 C C G T

A a b B C c g T

需要执行哪些我不知道的特殊SQL事情?

What special SQL thing needs to be done that I don't know about?

SELECT * FROM NOTES ORDER BY title

推荐答案

您也可以执行ORDER BY TITLE COLLATE NOCASE.

如果您需要指定ASC或DESC，请在NOCASE之后添加，例如

If you need to specify ASC or DESC, add this after NOCASE like

ORDER BY TITLE COLLATE NOCASE ASC

或

ORDER BY TITLE COLLATE NOCASE DESC

这篇关于如何使用SQL Order By语句对不区分大小写的结果进行排序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！