Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle / case sensitivity

Re: Oracle / case sensitivity

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 25 Feb 2003 11:37:31 +0100
Message-ID: <1046169447.860579@news.thyssen.com>


"Frederic L." wrote...
> Hi,
>
> Does anyone know if it is possible to render an Oracle server or an Oracle
> database case-INsensitive ?.
>
> Thx for any help
>
> Frederic
>
>

Hi Frederic,

not possible as far as I know.

1.) Don't use double (?) quotes when defining objects.
2.) You can catch data with upper /initcap / lower functions.
3.) You may need function based indexes.

hth,
Guido Received on Tue Feb 25 2003 - 04:37:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US