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 -> turn off/on case insensetive search in Oracle DBMS

turn off/on case insensetive search in Oracle DBMS

From: Bernd F. Dollinger <Bernd.Dollinger_at_dv-werk.de>
Date: Thu, 26 Jul 2001 23:02:11 +0200
Message-ID: <3B608553.8AB24E54@dv-werk.de>

Hello,

we want to do some SQL-statement like 'SELECT FROM table WHERE field1 = "name"' not be affected by case sensitivity as in result we get "name" or "Name". Our actual installation of Oracle 8 works case sensitive.

My DBA for our Oracle 8 DBMS told me, that it isn't possible to change this at the server site to "case insensitive".

A developer told me, he had read that the server site is configurable for "case insensitive" or "case sensitive" (what we have at the moment).

My question: Who is right?

Thanks for help
Bernd.

-- 
Bernd F. Dollinger
eMail: Bernd.Dollinger_at_dv-werk.de
Received on Thu Jul 26 2001 - 16:02:11 CDT

Original text of this message

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