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 -> Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

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

From: <fitzjarrell_at_cox.net>
Date: Wed, 18 Jul 2007 06:55:34 -0700
Message-ID: <1184766934.294114.238670@x35g2000prf.googlegroups.com>


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

Original text of this message

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