Re: CASE sensitive data....

A copy of this was sent to "Ulrik Hoffmann" <ulrik_at_hoffmann-kiel.de> (if that email address didn't require changing) On Mon, 26 Jul 1999 22:56:00 +0100, you wrote:

>Yes, it's case-sensitive on every machine.
>If you want to match Joe Smith and JoE sMiTH,
>you have some possibilities
>
>select * from table where upper(first_name)=upper('JoE') and so on.
>
>Oracle cannot use an index choosing this solution. If you want an
>case-insensitive index but case-sensitive display, you can work
>with a redundant upper-column.
>

well, in Oracle8i, release 8.1 we can create an index on upper(first_name) so that a query:

select * from table where upper(first_name)=upper('JoE')

can and will use an index. see my .sig for a link to a paper on this feature (function based indexes)

>
>
>Lisa Lombardo <llombardo_at_courion.com> schrieb in im Newsbeitrag:
>379CCA37.5024907C_at_courion.com...
>> I have Oracle 7.3.4 and 8.0.5 for NT installed on separate machines.
>> I noticed that verification of data against records in the Oracke
>> databases
>> are CASE-SENSITIVE.
>>
>> Is this true for ORacle 7.3.4 and 8.0.5 on UNIX systems, as well?
>>
>>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jul 27 1999 - 07:36:30 CDT