Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting NLS_COMP and NLS_SORT at the database level
On May 16, 1:50 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> ymong..._at_chca.ca schreef:
>
>
>
> > Hi,
>
> > I am running Oracle 10g Release 2 (10.2.0.1).
>
> > I have set theNLS_COMPparameter to LINGUISTIC and theNLS_SORT
> > parameter to BINARY_AI in the spFile through Oracle Entreprise
> > Manager. I have shut down and restarted thedatabase.
>
> >>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 SETNLS_COMP=LINGUISTIC
> > ALTER SESSION SETNLS_SORT=BINARY_AI
> > it works fine.
>
> > Is there another parameter to set in order to have this at the
> >databaselevel?
>
> > 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------ Hide quoted text -
>
> - Show quoted text -
I executed the SELECT on the server directly. Received on Thu May 17 2007 - 13:56:49 CDT
![]() |
![]() |