Hello,
I try to check the NLS_LANG Characterset of the Client bevor starting my software. At first I have tried sys_context('USERENV','LANGUAGE'), but this only retruns the Characterset of the database.
Now I have tried the dbms_system.get_env('NLS_LANG', r).
I have set the NLS_LANG environment variable to a different characterset from the database. But the result is the characterset of the database.
After that I have found the following text about the get_env procedure:
In Windows only registry values under the current Oracle home (per default HKLM\SOFTWARE\ORACLE\ KEY_OraDb10g_home1) can be retrieved. No system or user variables can be read, and the use of the ENVS parameter in the listener.ora is not supported on Windows.
So I have changed all NLS_LANG in my registry to a different characterset from database, but I also get the characterset of the database.
Please can somebody help me.
Regards
Bianca