Re: turn off/on case insensetive search in Oracle DBMS

From: Thomas Liang <liangluosheng_at_china.com>
Date: Fri, 27 Jul 2001 14:54:55 +0800
Message-ID: <9jr2nl$hmk$1@mail.cn99.com>

you can write
SELECT * FROM table WHERE UPPER(field1)='name'

> 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 Fri Jul 27 2001 - 01:54:55 CDT