Re: Case sensitive/insensitive?

mary_at_mitra.com (Mary E. Hunt) wrote:

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

why not force everything to uppercase regardless of what the user inputs. enforce it with a check constraint on the column. Received on Wed Jul 19 1995 - 00:00:00 CEST