Re: case INsensitive queries

From: Greg Kainz <gkainz_at_orapro.com>
Date: 1997/10/07
Message-ID: <343AFD28.DEE83AA9@orapro.com>#1/1

If you really want to store mixed case, then your queries should be like

select foo from bar
where UPPER(foo) = 'CRITERIA';

Another alternative is to force conversion to upper or lower case on insert,
either with the app or a table trigger...

Steve Larson wrote:

> Does anyone know of a way to store data in mixed case in an Oracle
> database,
> yet have Oracle ignore case when parsing where statements?
>
> Is it possible to acheive this by defining my own character set? Any
> hints on
> how to do this?
Received on Tue Oct 07 1997 - 00:00:00 CDT