Re: Oracle Case Insensitivity...

The definition of 'literal' means EXACTLY , so Memphis and MEMPHIS and Memphis are all different values ..

The only way to do what you want is to force the data to be stored in a pre-determined format ( either by a edit control on a form, or a trigger, or some other pre or post insert method) - that way the where clause can be in the format of the data since it will be known..  

"Pablo Sanchez" <pablo_at_dev.null> wrote:

>
>"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. :)

-----------== Posted via Newsfeeds.Com - Uncensored Usenet News ==----------

   http://www.newsfeeds.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =----- Received on Thu May 02 2002 - 11:05:04 CDT