Case sensitive/insensitive?

Oracle appears to be case sensitive when executing a query on a char/varchar2 type of field. I would like the data to be entered what ever way the user wishes, but would like to be able to query the data without using the upper() function, as this won't use the index.

I know MS-Access is case insensitive. Ie I enter a value into col1 as "Text" and I can select where col1 = 'text'.

What is the standard for SQL databases?? Case sensitive on character fields or case insensitive?

If you have any ideas, because I am going to have to figure out a work around for Oracle being case sensitive. Received on Tue Jun 06 1995 - 00:00:00 CEST