Special Characters Created on a UNIX system with HP Terminal on US7ASCII

Hi all,

I have a customer who uses an application on a UNIX server. The database (US7ASCII, 9i) is on a Windows server. The system was migrated from a 2-tier solution before meaning the application and the database were on UNIX before.

The problem is that clients and SQLPlus on Windows computers get wrong special character like German Umlaute or °-sign.

The application itself works fine and reports and static created before the migration are printed okay and shown in UNIX tools of the software correctly (on the UNIX box using HP terminal) . In other words the application is fine with the setup only the Windows clients show wrong characters and write back wrong characters to the DB.

The data was entered using HP terminals before the migration to my knowledge. Any Idea what is to be adjusted that the Windows clients read the special characters correctly again?

The nls_lang settings are US7ASCII on all three tiers. The dump function shows the e.g. the German "ü" is stored as &CF in the database.

Any help appreciated.

Thanks,

Gerrit Received on Tue Jul 17 2007 - 08:46:59 CDT