Oracle ODAC: NLS_LANG in registry

The Oracle ODAC (11.2.0.3.20) installation is creating an NLS_LANG entry in here:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG

And that has no effeckt – it should be placed in an oracle_home – like:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG

The result of having the NLS_LANG in the wrong place is special characters like JP, trademark, copyright and local country characters is shown as question marks.

To fix the issue you need to create the NLS_LANG entry in the oracle_home. We found that, with the database NLS_LANG = AMERICAN_AMERICA.AL32UTF8, client NLS_LANG = AMERICAN_AMERICA.UTF8 – and all characters is now shown correctly.

This entry was posted in Applications development, Installation, News, SQL, xls4oracle. Bookmark the permalink.