This content has been marked as final. Show 1 reply
In general you have to set HS_LANGUAGE=american_america.al32utf8 and charset UTF8. But it also depends if you have set a NLS_LANG value in your environment where you have started your listener. It is also essential to know which utility you are using to query the content. SQL*Plus? If yes, are you using it on Windows or in a Termianl Session and if it is a Terminal session what's the charcter setting of your putty window and the LANG setting of your console?
To avoid Terminal settings and SQL*Plus issues, I would recommend to use the unicode tool SQL*Developer which is using Unicode in its display window by default.It can be downloaded from here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html?ssSourceSiteId=ocomen