Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


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.

share|improve this question

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 ....

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.