I just started working with the SQLite database places.sqlite.
Fact is that this database uses case sensitive collate sequences making writing queries as funny as in Oracle.
I want to know, are there really any applications where the user wants case sensitive sorting.
Or is the default use of case sensitive sorting a heritage of the fact that binary sort order is cheaper than the other forms.
EDIT:
Just in case you are curious. SQLite can handle caseinsenitive compares. see this SO question
BTW what is the state of art with Oracle. We migrated our SQL databases to ORACLE at the time of 8i and never checked, if we can do it caseinsensitive today.
Best Answer
In oracle it is possible since 10.2. Take a look here Case-Insensitive and Accent-Insensitive Linguistic Sorts,so you might want to take a look again, 8i is a while ago now ....