1010223 wrote:I wonder if that's the problem, then?
1 NLS_LANGUAGE AMERICAN
2 NLS_TERRITORY AMERICA
9 NLS_CHARACTERSET WE8MSWIN1252Now, the character set itself matches, however, the language and territory doesn't. I myself, am not 100% if that's having an effect - hopefully somebody else more knowledgeable can help :) Sorry I can't help more than that. You might try that, though. It won't hurt to change 1 PC windows registry to match the database, and see if it has an effect. If not, change it back.
When I use procmon to monitor our appliction, I could only find 1 entry with NLS_LAN:
HKLM\SOFTWARE\Wow6432Node\ORACLE\NLS_LANG, but the result was: NAME NOT FOUND.
When I use regedit, this entry doesn't exists: link
In the oracle.key file I found this:
But that doesn't exists either.
In regedit, this was the only hit for NLS_LANG:
SET in command prompt didn't show a record for NLS_LANG.
What is the best solution? Is this a bug?
When I add this entry: HKLM\SOFTWARE\Wow6432Node\ORACLE\NLS_LANG, then everything seems to work. But maybe there is a better solution?