Re: Case sensitive

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 29 Jun 2005 10:55:29 -0400
Message-ID: <3ifr34Flavc4U2@individual.net>

HansF wrote:
> On Wed, 29 Jun 2005 04:35:20 -0700, daniellopez21 interested us by
> writing:
>
>

>>I have problem with "case sentitive" in Oracle.
>>
>>When I use the UPPER function, sql statment not acces by index.
>>
>>How I can disable de "case sensitive" of oracle

>
>
> Learn about 'Function Based Indexes'.
>
> (Also realize that using an index is not always the best, or fastest, way
> of getting data.)
>

Hans,

What about a case insensitive collation?

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Received on Wed Jun 29 2005 - 09:55:29 CDT