RE: Case insensitive search

From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: Tue, 30 Jan 2007 19:33:19 -0500
Message-ID: <000001c744cf$67b5df80$6401a8c0@MN>

Harvinder,

NLS parameters must be set on client site. If client is on Windows, most likely you will find NLS_LANG set in registry - something like NLS_LANG=American_America.WE8MSWIN1252
Other NLS parameters are derived from this setting (unless you will change settings on session level).

Regards
Mindaugas

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh
Sent: January 30, 2007 4:22 PM
To: oracle-l
Subject: Case insensitive search

Hi,

When we set the following parameters on the client machine with alter session it works fine and we get case insensitive searches but when we try to set this in spfile it only affects the sessions on the database machine:
NLS_SORT='BINARY_CI'
nls_comp='LINGUISTIC'

Is there any way we can change this settings at the instance level so that we don't have to use logon trigger to set this at session level?

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 30 2007 - 18:33:19 CST