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

Home -> Community -> Usenet -> c.d.o.server -> use command set sqlcase upper from within VB 6.0 app ?

use command set sqlcase upper from within VB 6.0 app ?

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Mon, 22 Jan 2001 14:32:00 +0100
Message-ID: <eido6t0khgog05bcijrlgevk01lgmtqa46@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 - 07:32:00 CST












Original text of this message













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