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

Home -> Community -> Usenet -> c.d.o.server -> Re: Please help me out on this

Re: Please help me out on this

From: Tim Hentzel <thentzel_at_silicon-age.com>
Date: Thu, 12 Oct 2000 07:39:05 GMT
Message-ID: <8s3pqp$t3g$1@nnrp1.deja.com>

how about updating the contents of the column to all uppercase and then transforming the query text to uppercase before running the query, as opposed to in the query.

hth,
tim hentzel

http://www.codegarden.com

In article <Ag3F5.48$wu.2419_at_sjc-read.news.verio.net>,   "kush" <kdhakal_at_eline.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 02:39:05 CDT

Original text of this message

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