Re: use command set sqlcase upper from within VB 6.0 app ?

From: Spencer <spencerp_at_swbell.net>
Date: Fri, 26 Jan 2001 20:33:48 -0600
Message-ID: <fsqc6.82$7i7.7967@nnrp1.sbc.net>

No. Oracle is case sensitive. If you want upper or lower case, you can use the builtin UPPER() or LOWER() functions on any character expression.

"Bernd Rosenau" <brosenau_at_gss-online.de> wrote in message news:eido6t0khgog05bcijrlgevk01lgmtqa46_at_4ax.com...
> Hi,
>
> our VB 6 application uses ADO to access tables on a Oracle 8 server.
> Our clients are asking for case insensitive searching.
>
> I found out that one can switch this feature on with the command SET
> SQLCASE UPPER but this seems only to work within SQL PLUS.
>
> Is there a way to make the setting SQLCASE UPPER valid for the whole
> Oracle server and therefore for my VB 6 program or is there a way to
> set SQLCASE to upper by using ADO ?
>
> Many thanks in advance
>
> Cheers Bernd
>
>
>
Received on Fri Jan 26 2001 - 20:33:48 CST