Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to configure my database or server to be case-insensitive

Re: how to configure my database or server to be case-insensitive

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/10/26
Message-ID: <711aif$5da$2@news02.btx.dtag.de>#1/1

Hi,

Bob Nightingale schrieb:
>
> I would use a trigger on the tables to convert every entry to UPPER. But
> you would have to add that on all columns that have char or varchar2 on
> every new table. The other was is to change your select statement to be
>
> select * from user_table where upper(user_name) like 'JOHN';

Be aware that no index will be used.

>
> --Bob.
>
> Rick Lin wrote in message <70qiqe$gd3$1_at_news1-alterdial.uu.net>...
> >Hi,
> >
> >Is there anyway to configure my database or server to be case-insensitive?
> >In other words, I would like my database or server to ignore case while
> >doing
> >text literal comparsion in all SQL statements. For example, the following
> >criteria in where clause will return the same result:
> > SELECT * FROM user_table WHERE use_name= 'john'
> > SELECT * FROM user_table WHERE use_name= 'John'
> > SELECT * FROM user_table WHERE use_name= 'JOHN'
> > SELECT * FROM user_table WHERE use_name= 'jOhn'
> >
> >Thanks,
> >
> >Rick Lin
> >Diffusion, Inc.
> >rlin_at_diffusion.com
> >
> >
> >
> >
 

-- 

Regards

Matthias Gresz    :-)


Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm
Received on Mon Oct 26 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US