Marco Schaffh
Member
Hello,
when issuing a
when issuing a
Code:
SELECT '
Problems with german characters
- Thread starter Marco Schaffh
- Start date
What happens if you start C:\oracle\product\10.2.0\client_1\bin\sqlplus.exe, connect to the same database, and run the same query?
Marco Schaffh
Member
Hello Marco,
you're perfectly right, SQL-Plus is acting strange too. So I have to change my directive to find the right parameters for the Oracle-Client.
Thanks, Marco
you're perfectly right, SQL-Plus is acting strange too. So I have to change my directive to find the right parameters for the Oracle-Client.
Thanks, Marco
Marco Schaffh
Member
The problem is solved.
The parameter NLS_LANG was defined in the registry, but was somehow not accepted by Oracle-Net.
After defining the parameter as an environment-variable everything works fine.
With regards, Marco
The parameter NLS_LANG was defined in the registry, but was somehow not accepted by Oracle-Net.
After defining the parameter as an environment-variable everything works fine.
With regards, Marco
Marco Schaffh
Member
In case someone else is facing the same problem, I should have been more precise.
The parameter NLS_LANG had been defined within the registry-key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1 Although I've seen several machines defining it in the 'Home'-Section, it obviosly was not evaluated in my case.
If NLS_LANG is defined within HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, it's value will be considered in the session-settings.
HTH, Marco
The parameter NLS_LANG had been defined within the registry-key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1 Although I've seen several machines defining it in the 'Home'-Section, it obviosly was not evaluated in my case.
If NLS_LANG is defined within HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, it's value will be considered in the session-settings.
HTH, Marco
Similar threads
- Discussion
