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

How many more requests along these lines are we to see here, posted at interminably regular intervals? Doesn't anyone bother reading Deja.com any more?

OK, one more time then: Oracle is not case insensitive, and is unlikely so to become anytime in the future. Feed it "Scott", and it stores "Scott". Feed it "SCOTT" and it stores "SCOTT".

It's up to the application to make sure it feeds the backend with the data that is supposed to be stored. SQLPLUS is an application: it has application tricks it can pull off to force uppercase, as you have discovered. But that's the application doing the deed, not Oracle.

ADO may or may not have similar tricks -I simply don't know. But forget any idea of throwing a switch inside Oracle itself. In 8.1.5 and upwards, you can simulate such a trick by building function-based indexes on particular columns. But that's about it.

HJR "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 Mon Jan 22 2001 - 20:34:17 CST