Re: CASE sensitive data....

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Mon, 26 Jul 1999 22:56:00 +0100
Message-ID: <7nii25$542$1@freeside.cls.net>

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.

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?
>
>
> I have a record that has FirstName and Lastname (JOE SMITH and Jane
> Doe).
> I have to type the same letters using the same case as in the DB to
> match.
>
> Joe Smith does not match JOE SMITH. joe smith does not match JOE SMITH.
> Only JOE SMITH matches.
>
> I want to know if it is safe to conclude that the same case-sensitivity
> exists with ORacle databases on UNIX systems.
>
> Please reply here and to my email address above.
Received on Mon Jul 26 1999 - 16:56:00 CDT