I have been using SQL Navigator 6.2. for several years with Oracle 11.2 g on Windows 7 32bit.
Now I got a new machine with Windows 7 64bit. Since then I am experiencing stranges problems with special characters (german Umlaut) in the code editor.
I can retrieve data from tables and the special characters are displayed correctly, I also can edit the data in the grid:
But when I run a script, these characters are displayed as ¿
and every package I edit and run is also effected:
When I open a DDL skript (chars are ok) and run it, the created oracle object shows the wrong chars.
Windows region format is Deutschland (Österreich).
The oracle session parameters are set as followed:
NLS_DATE_FORMAT DD.MM.YYYY HH24:MI:SS
NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
It seems to me that something is happening during compiling the scripts.
Thank you for any advice