OraFAQ Forum: Server Administration » How to set NLS

Home » RDBMS Server » Server Administration » How to set NLS_LANG parameter in Linux / Solaris

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set NLS_LANG parameter in Linux / Solaris [message #56069]

Wed, 05 March 2003 00:24

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hello all,
using regedit if we got to Oracle_home -> Home0 -> NLS_LANG we can set this character set in Windows platforms.. where can we set this for Linux ?
I have a value as AMERICAN_AMERICA.WE8ISO8859PI for windows and i want to set the same for Linux and Solaris also.. Please let me know about it..

Also help me in the below issue ...what should i do to avoid the below problem ..

[b]

sql> connect scott/tiger@Windowsbox

sql>desc sample
Col1 varchar2(20)

Sql> insert into sample values('�');
1 row(s) created

Note: shortcut to '�' is Alt + 1254

Sql> select * from sample;
�

1 row(s) selected.

now,
sql>connect scott/tiger@linuxbox

sql>desc sample
Col1 varchar2(20)

Sql> insert into sample values('�');
1 row(s) created

Sql> select * from sample;
?

1 row(s) selected.

How to avoid this problem . I understand its some character set problem ... Help me in this regard..

Thanks and Regards
sai

Report message to a moderator

Re: How to set NLS_LANG parameter in Linux / Solaris [message #56078 is a reply to message #56069]

Wed, 05 March 2003 05:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I beleive, you can just export it as a envrionment variable..

linden:/u01/app/oracle/product/8.0.5 >
echo $NLS_LANG
AMERICAN_AMERICA.US7ASCII
linden:/u01/app/oracle/product/8.0.5 >

Report message to a moderator

Re: How to set NLS_LANG parameter in Linux / Solaris [message #56082 is a reply to message #56069]

Wed, 05 March 2003 06:50

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hello mahesh,
YEah i did the same, but no effect ..

Anyways, I am trying...

sai

Report message to a moderator

Previous Topic:	9i Installation - attention Mahesh Rajendran
Next Topic:	storing images

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:33:01 CDT 2024