Oracle Case Insensitivity...

From: ARP <sirapitt_at_hotmail.com>
Date: Wed, 1 May 2002 21:07:03 -0400
Message-ID: <ud15hclrcho751@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.

Thanks in advance. Received on Wed May 01 2002 - 20:07:03 CDT