Re: case sensitivity

From: spencer <spencerp_at_swbell.net>
Date: Thu, 7 Sep 2000 21:54:31 -0500
Message-ID: <4xYt5.420$3S.101633@nnrp1.sbc.net>

Oracle is case sensitive. The workaround is to use a function to translate to either upper or lower case. e.g. WHERE UPPER(expression) = UPPER(expression)

"sp" <sdpant_at_yahoo.com> wrote in message news:VxVt5.5876$R87.165393_at_sjc-read...
> We are on the process of replacing a sql server 7 db with a oracle db
> server. Since the sql server does not care whether the data is case
> sensitive we're facing problem retriveing the data ( for eg. searches) from
> oracle which is case sensivtive -- and it will be on the network with other
> sql server databases.
>
> Is there a way to make the oracle db case insensitive? Is there a work
> around? Has anyone come accross this problem?
>
> Any input is appreciated.
>
> TIA
> SP
>
>
>
>
>
Received on Thu Sep 07 2000 - 21:54:31 CDT