Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Special Characters Created on a UNIX system with HP Terminal on US7ASCII

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

From: gk24 <gk24_at_nurfuerspam.de>
Date: Tue, 17 Jul 2007 06:46:59 -0700
Message-ID: <1184680019.264446.227680@j4g2000prf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US