HOW TO CONFIGURE nls_lang for utf8
507581Apr 11 2007 — edited Apr 12 2007can you please help me how to display follwing special characters in sqlplus .
i have installed 10g.Release 10.2.0.1.0
whats wrong with characterset
SQL> select \'à è ì ò ù @ ç° § à À á Á è È é É ì Ì í Í ò Ò ó Ó ù Ù ú Ú « »\' from
dual ;
2
'?????@?????????????????????????'
------------------------------------------------------------
? ? ? ? ? @ ?? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
albeit I tried to change environment variables but it didnt work.
[oracle]$ NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
[oracle]$ export $NLS_LANG
-bash: export: `AMERICAN_AMERICA.AL32UTF8': not a valid identifieORA$
[oracle]$ NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle]$ export $NLS_LANG
-bash: export: `AMERICAN_AMERICA.AL32UTF8': not a valid identifieORA$