Re: Oracle Case Insensitivity...

"ARP" <sirapitt_at_hotmail.com> wrote in message news:ud15hclrcho751_at_corp.supernews.com...
> Configuration Question:
>
> How does one go about setting an Oracle Server installation to be
Case
> Insensitive for the comparison of literal strings via "WHERE"
clauses in SQL
> statements. As an example, I want to configure my server such that
the
> clauses [where CITY = 'MEMPHIS'] and [where CITY = 'Memphis'] return
the
> same result sets.
>
> The 9i documentation is not very expressive on this particular
subject (one
> of the few). I did find an NLS setting called NLS_COMP which can
have values
> of ANSI and BINARY where the latter is the default, but I need to
know
> conclusively what the deal is here.
>
> BTW, I am fully aware of use of the UPPER() function in
ANSI-compatible SQL.
> That is besides the point for the purpose of this discussion.

Your best bet to solve your issue is to build function based indexes on the columns that require it.

It's not exactly what you're seeking but better than a poke in the eye. :)

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts