Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Host command to change NLS_LANG

spur230Jan 6 2012 — edited Jan 10 2012

I am using Oracle 11g 11.2.0.2.0 .

I want to insert é chacater but it is getting inserted as ¿. My NLS_CHARACTERSET is WE8MSWIN1252.

From sqlplus in Sun OS, when i run
+!echo $NLS_LANG+
It is returning null.

Setting client evironmental variable by issuing bellow command resolved the issue
export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

However, I will have permission issue to change NLS_LANG variable in upper environments. I tried issuing
Host or ! command from within sqlplus as HOST export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252 from within SQLPLUS but it is not setting NLS_LANG variabe. I do not get any errors either.

Please let me know how can I set NLS_LANG from within sqlplus or any other method to correctly insert é character?

Thank you.

This post has been answered by orafad on Jan 10 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2012

Added on Jan 6 2012

#database-key-features, #globalization-support

8 comments

3,011 views