Re: Please help me out on this

From: Porus H Havewala <porushh_at_bigpond.com>
Date: Thu, 12 Oct 2000 13:44:12 +1100
Message-ID: <39E5257C.6CE04534@bigpond.com>

Hi Kush,

There is no way to turn off case sensitivity in Oracle - the only solution for your issue is to upgrade to 8i which has the feature you mention - function based indexes, which will solve this issue.

Regards,

Porus.

kush wrote:

> Hi! we are using Oracle 8 standard edition, The problem is when user does
> query from web site for text field he or she may type in Ucase or Lcase
> letter, but since Oracle is case sensitive(I believe), if I applied upper or
> lower function on both side of where clause it will suppress the index on
> the column causing performance problem and function based index is not
> supported on Oracle 8standard editiond. so is there any way I can turn off
> case sensitivity of oracle and if not how can I get around this problem? any
> hint will be appreciated. thanks.
>
> kush
Received on Wed Oct 11 2000 - 21:44:12 CDT