Problem with special characters SQL Navigator 6.2 Win7 64 bit

SQL Navigator
1

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_LANGUAGE GERMAN
NLS_TERRITORY GERMANY
NLS_CURRENCY EUR
NLS_ISO_CURRENCY GERMANY
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD.MM.YYYY HH24:MI:SS
NLS_DATE_LANGUAGE GERMAN
NLS_CHARACTERSET WE8ISO8859P15
NLS_SORT GERMAN
NLS_TIME_FORMAT HH24:MI:SSXFF
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
NLS_DUAL_CURRENCY €
NLS_NCHAR_CHARACTERSET AL16UTF16

It seems to me that something is happening during compiling the scripts.

Thank you for any advice
Manuela

2

Hi Manuela,

SQL Navigator 6.2 was not full support unicode, we suggest that upgrade to 7.0+ or latest version, that will be full support unicode.

Thanks,

Michael

3

Hi Michael,

but why did it work on the 32bit machine with version 6.2?

I tried to install the trial version 7.2 but I could not get it running because of “oci.dll not found” error. All hints and suggestions I found for this issue did not work for me.

Kind regards

Manuela

4

Hi Manuela,

when you use version 7.2 for 64bit, you must install oracle client for 64 bit too.

64bit Nav match 64bit oracle client.

Regards,

Michael

5

Hi Michael,

I don’t know how, but today version 7.2 is working, maybe the reboot solved the problem - sorry for this confusion.

You are right, the special characters are working with the newest version.

Thank you!

Kind regards.

6

That’s good news that you can work of version 7.2