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

On Jul 17, 8:46 am, gk24 <g..._at_nurfuerspam.de> 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

The question becomes what is your nls_characterset? I'd be querying V $NLS_PARAMETERS to find out.

David Fitzjarrell Received on Wed Jul 18 2007 - 08:55:34 CDT