Re: Is Oracle is CASE SENSITIVE

From: Norris <jcheong_at_cooper.com.hk>
Date: 27 Oct 2000 01:10:06 GMT
Message-ID: <8takle$ahv2@imsp212.netvigator.com>

This question should be put into Oracle FAQ

Fri, 27 Oct 2000 01:07:00 +0200 Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> There is no need to mention that as the world (except for the Microsoft
> empire) is case sensitive.
> Oracle can't do case insensitive searches. In fact, I respond this to this
> same question several times a week, and it is getting a bit boring. A search
> on deja.com shouldn't have turned up a blank.
> You need to
> - use redundant upper or lower cased columns (7.3 and 8.0)
> - or use function based indexes (Oracle 8i *enterprise*)
> - or wait for someone promoting their OMNIDEX product (you would have found
> that of course with a search on deja also).
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Bji" <bmahadev_at_hotmail.com> wrote in message
> news:bk1K5.143$UO3.5884_at_newsfeed.intelenet.net...

>> Hello
>> Is Oracle is case sensitive. If yes, i did not find anywhere in the oracle
>> manual about this. Can any one tell me where to mention for the oracle to

 do

>> case in-sensitive search..
>> Thanks in advance
>> Bji
>>
>>

>
>

-- 
e-Consultant
http://www.asl.com.hk/employment.htm
http://www.eroom.com

Received on Thu Oct 26 2000 - 20:10:06 CDT