Re: Oracle Case Insensitivity...

From: Pablo Sanchez <pablo_at_dev.null>
Date: Thu, 2 May 2002 12:05:47 -0600
Message-ID: <1efA8.644$VQ6.482873@news.uswest.net>

"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:dmo2dussk52o8nci12i1f8olqrrn1sldji_at_4ax.com...
>
> The definition of 'literal' means EXACTLY , so Memphis and MEMPHIS
and Memphis are all different values ..
>
> The only way to do what you want is to force the data to be stored
in a pre-determined format ( either by a edit control on a
> form, or a trigger, or some other pre or post insert method)
> - that way the where clause can be in the format of the data since
it will be known..

I'll let the poster answer for hisself but I do believe what s/he is intending is to have mix-cased stored in the DB and have the end-user type in any string, which will then be matched using an index. Could be wrong of course ...

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts

Received on Thu May 02 2002 - 13:05:47 CDT