Language & Character Set Clarifications

[faraz.gilane]

Dear Erman,

We were facing a unique situation with one of the special characters. :[ µ ]

The oracle db has identified and stored it in the database however when we execute a function in Linux -[sqlplus] which passes the [ µ ] as an input parameter string, the value returned is " ?? " [unidentified].

When we added a environmental parameter in Linux : export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 and executed the same function again the outputs were correct and the special character[ µ ] was being returned.

Reference for solution: http://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html

Oracle User Environment Language : AMERICAN_AMERICA.AL32UTF8 [SELECT USERENV ('language') FROM DUAL;]
RHEL $LANG : en_US.UTF-8
Remote terminal [Putty] config : UTF-8 [Remote character set]

Please advise if there is any other issue in adding the NLS_LANG environmental variable as we are constantly populating a lot of data in our databases and would not like to disrupt the day or day activities or corrupt any data.

Thanks for your time.

[ErmanArslansOracleBlog]

You need to set the environment variable in Linux.
set it in the bash_profile.
set that LANG profile in your .bash_profile of your OS user and reconnect to Linux to make the .bash_profile  be resourced.
After that retry.


You can also configure it in the tool that you are connecting to Linux .
For example: putty. You can do that configuration with the following navigation "Change Setting >Window-Translation > choose the characterset you need."

I m attaching an example screenshot for this as well.

[faraz.gilane]

Thanks for replying !