Case insensitive search

From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 30 Jan 2007 16:22:23 -0500

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

Follow-Ups:

RE: Case insensitive search
From: Mindaugas Navickas

RE: Case insensitive search
From: Yasin Baskan

Case insensitive search

Other related posts: