Search code examples
oracle-databaseencodingplsqlglobalizationplsqldeveloper

How to read Chinese Characters from Oracle UTF8 Database using PLSQL Developer


I have an Oracle Database with character set AL32UTF8, but I am not able to read some information (ex. Chinese characters). How can I configure my PLSQL Developer to read these characters?

By the way, when I read this information it appears such as ???

I'm using Windows XP.


Solution

  • I found the answer by myself.

    It's necessary to change the NLS_LANG registry in the following route HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ODACHome2

    And set it with the properly language. In my case it was : AMERICAN_AMERICA.AL32UTF8

    Anyway...Thanks.