Re: Case in-sensitive searches

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 20 Oct 2000 21:06:57 +0200
Message-ID: <972072931.9726.0.pluto.d4ee154e@news.demon.nl>

Yes, you'll need before insert or update for each row, and :new.<column_name>:=upper(:new.<column_name>)

Hth,

Sybrand Bakker, Oracle DBA

"Norris" <jcheong_at_cooper.com.hk> wrote in message news:8sprtb$8qc5_at_imsp212.netvigator.com...
> For option 1, is it correct to use trigger to convert to upper?
>
> Fri, 20 Oct 2000 16:56:38 +0100 Christopher M. Day
<christopher.day_at_rdbms.freeserve.co.uk> wrote:
> > Bji,
> >
> > Couple of options
> >
> > 1. Load all data in one case either upper or lower
> > 2. Use Oracle8i functional indexes and create an UPPER(column) index
> > and code this in all queries
> >
> > Chris
> >
> > Bji wrote:
> >>
> >> Does any one know, is it possible to configure oracle server to do case
> >> in-search whenever any query is performed.
> >> Thanks
> >> Bji
>
>
> --
> e-Consultant
> http://www.asl.com.hk/employment.htm
> http://www.eroom.com
Received on Fri Oct 20 2000 - 14:06:57 CDT