Re: Case sensitive/insensitive?

In article <MARY.95Jun6153638_at_shark>, <mary_at_mitra.com> writes:
> Path:

interramp.com!psinntp!psinntp!news.nyc.pipeline.com!newsjunkie.ans.net!howland. reston.ans.net!swrinde!hookup!remus.wat.hookup.net!witch!mary
> From: mary_at_mitra.com (Mary E. Hunt)
> Newsgroups: comp.databases.oracle
> Subject: Case sensitive/insensitive?
> Date: 06 Jun 1995 19:36:38 GMT
> Organization: Mitra Imaging Inc. Waterloo, Ontario.
> Lines: 14
> Message-ID: <MARY.95Jun6153638_at_shark>
> NNTP-Posting-Host: shark.mitra.com
>
>
> 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.
>

Oracle is case sensitive. The only way around it is what you said to use either the lower() or upper() functions. If case is not an issue in your application, then I would suggest enforcing all upper (or lower) case in all the column, by way of the application - SQLFORMS or creating constraints on the columns. I like the latter because it enforces the business rule from any DML. Received on Wed Jun 14 1995 - 00:00:00 CEST