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

Home -> Community -> Mailing Lists -> Oracle-L -> NLS_COMP and NLS_SORT

NLS_COMP and NLS_SORT

From: Simone Saravalli <s.saravalli_at_gmail.com>
Date: Thu, 20 Apr 2006 11:46:45 +0200
Message-ID: <33ee34370604200246gd047979naefb34347913d456@mail.gmail.com>


Hi all, I'm looking for character sets and collation with Oracle. About character set from the shell I have:

$ locale character

utf-8

and

$ echo $NLS_LANG

AL32UTF8 Now I'm also looking for collation, ie the comparaison between strings and I've found other two environment variables: NLS_COMP and NLS_SORT, but I don't understand how to set them permanently (if it's possible). If I use an alter session statement to set NLS_SORT and NLS_COMP the change is conscripted to a single user session. So, exists a way to set the two paramethers permanently?

Thanks, Simone Saravalli

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 20 2006 - 04:46:45 CDT

Original text of this message

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