Re: Case in-sensitive searches

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