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

"Bernd F. Dollinger" wrote:

> 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

Your DBA.

Daniel A. Morgan Received on Thu Jul 26 2001 - 17:04:15 CDT