Re: Setting NLS_COMP and NLS_SORT at the database level

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 16 May 2007 19:50:41 +0200
Message-ID: <f2fg8m$a0u$2@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

ymongeau_at_chca.ca schreef:
> Hi,
>
> I am running Oracle 10g Release 2 (10.2.0.1).
>
> I have set the NLS_COMP parameter to LINGUISTIC and the NLS_SORT
> parameter to BINARY_AI in the spFile through Oracle Entreprise
> Manager. I have shut down and restarted the database.
>

>>From Oracle Entreprise Manager (/Administration / All initialization

> parameters), I can see that the values for the parameters are the ones
> mentioned above. However, I cannot perform a case-insensitive and
> accent-insensitive search.
>
> If I change it at the session level
> ALTER SESSION SET NLS_COMP=LINGUISTIC
> ALTER SESSION SET NLS_SORT=BINARY_AI
> it works fine.
>
> Is there another parameter to set in order to have this at the
> database level?
>
> Thanks for your help.
>

What are your client-side settings?

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGS0RxLw8L4IAs830RAnGOAKCBktpZHiY118gkBi1sFEZtXyUmUQCfYzF6 OFnS6ifdjaLA0muXn7vsREE=
=y4d4
-----END PGP SIGNATURE----- Received on Wed May 16 2007 - 12:50:41 CDT