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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 17 Jul 2007 21:35:45 +0200
Message-ID: <f7j5ma$pa2$3@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gk24 wrote:
> 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
>

Look up which characterset uses CF for the Umlaut. Then, change the nls_lang setting to that on the Windows clients. Not anywhere else!

Character mappings can be found in the Globalization manual(s) at http://tahiti.oracle.com

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGnRoRLw8L4IAs830RApEwAKCPs2TZ2/94IfxQKuUKXNs7Z7BzpACfSXOt jn7PWAPALkkZOz4NE2XogB0=
=dFyG
-----END PGP SIGNATURE----- Received on Tue Jul 17 2007 - 14:35:45 CDT