Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CASE sensitive data....
thanks for your input.
Are there settings in ORACLE DB that can override the case-sensitivity
on a
column(field) basis?
Lisa
Thomas Kyte wrote:
>
> 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
--
Courion Corporation Lisa Lombardo 16 Tech Circle llombardo_at_courion.com Natick, MA 01760 508-650-0330x203 www.courion.com Fax:508-650-0001 "Surf to Solve..." ============================================Received on Wed Jul 28 1999 - 13:24:56 CDT