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 B C T a b c g
I want to get:
A a b B C c g T
What special SQL thing needs to be done that I don't know about?
SELECT * FROM NOTES ORDER BY title
This question is related to
sql
sqlite
sorting
sql-order-by
You can also do ORDER BY TITLE COLLATE NOCASE.
Edit: If you need to specify ASC or DESC, add this after NOCASE like
ORDER BY TITLE COLLATE NOCASE ASC
or
ORDER BY TITLE COLLATE NOCASE DESC
You can just convert everything to lowercase for the purposes of sorting:
SELECT * FROM NOTES ORDER BY LOWER(title);
If you want to make sure that the uppercase ones still end up ahead of the lowercase ones, just add that as a secondary sort:
SELECT * FROM NOTES ORDER BY LOWER(title), title;
SELECT * FROM NOTES ORDER BY UPPER(title)
Source: Stackoverflow.com