Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] SQLite - Sort text case insensitive
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter
November 20, 2013 6:02 PM
When you do a ORDER BY a field say "title" which has for example the following values,
title
-----
c
a
D
Z
B
X
then with:
SELECT ... ORDER BY title ASC;
You'll get:
B
D
X
Z
a
c
To sort this case insensitive use:
SELECT ... ORDER BY title COLLATE NOCASE ASC;
and you'll get the right order:
a
B
c
D
X
Z
