Toad World® Forums

Problem with special characters SQL Navigator 6.2 Win7 64 bit

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

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

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

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

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.

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