Re: string case insensitive comparisons with Oracle

From: Larry <lculver_at_my-deja.com>
Date: 2000/04/26
Message-ID: <8e74uv$b18$1@nnrp1.deja.com>#1/1

No, string comparisions are very case sensitive.

And yes if this comparision is in a join you can kiss your index scans good-bye. Assuming that this is the reason for your question AND forcing all the data in your DB to upper case is NOT an option then your best bet is to create a column(s) in the table(s) that does force the data to upper case and put an index on those column(s).

Example:

Table Employees

First_Name Varchar2(20) (mixed case) Upper_First_Name Varchar2(20) (upper case) Put index on this column.

Larry

In article <8e737a$8uj$1_at_nnrp1.deja.com>, willmccormick_at_my-deja.com wrote:
> Is there a way with Oracle to have string comparisions be cas
> insensitive without using LOWER, UPPER or INDEX Functions?
>
> Sincerely,
>
> William McComick
>
> P.S. Please ignore this if my previous message went through. :]
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT