Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting NLS_COMP and NLS_SORT at the database level

Re: Setting NLS_COMP and NLS_SORT at the database level

From: <ymongeau_at_chca.ca>
Date: 17 May 2007 11:56:49 -0700
Message-ID: <1179428209.469166.286830@w5g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US