RE: Case insensitive search

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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

Other related posts: