Quote Originally Posted by hany View Post
You use NLS_LANG to let Oracle know what characterset the OS is using. This is important so that Oracle would do characterset conversion from client characterset to the database characterset.

The question here would be why do you have two different NLS_LANG setting on the same server?
I have two databases that use different NLS_LANG and ceach time when I switch from one database to another I have to change NLS_LANG parameter in registry.