Question about NLS_LANG

Hello,

How can I change the NLS_LANG=American_America.WE8ISO8859P1 for display €?

Thanks

bibi
bibi92Asked:
Who is Participating?
 
Devinder Singh VirdiConnect With a Mentor Lead Oracle DBA TeamCommented:
You can also set this parameter at OS level in unix using the following:-
export NLS_LANG=american_america.WE8ISO8859P15

Use alter session for session level.
0
 
schwertnerCommented:
Look here for the character sets of the DB that support Euro.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/applocaledata.htm

But your DB has to be created with that character set. Otherwise it will not store that sign.
0
 
PilouteConnect With a Mentor Commented:
Hi,

WE8ISO8859P1 character set does not support euro caracter. as schwertner said, you have to go for another characterset for your database if you want to store that caracter.

If your database uses a charset that is able to store euro signs, then it is your own client (let me guess, windows desktop ?) which might not display euro sign correctly...

Since your question is pretty unclear, lets clarify this : you need both your database (in order to store euro sign correctly) and your client (in order to display the caracter correctly) to use 'euro compatible' charsets.

Cheers,
P
0
 
bibi92Author Commented:
Thanks bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.