3

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.

1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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