Re: Upper ASCII characters - Above 126

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 1997/06/25
Message-ID: <01bc80da$e8a22ea0$6b82f1c3@worldonline>#1/1

Werner <werner.smit_at_baps.com> schreef in artikel <33AB78E1.35B0_at_baps.com>...
> Hi there oracleers!
>
> I'm trying to add data to a varchar2 field tru a third party product
> like ODBC over SQL*Net and tcp/ip on a WindowNT machine on to an oracle
> database living on a Solaris system.
> All my higher ASCII characters are unfortunately translated to question
> marks of ascii value 63.

Hello Werner,
You probably have a 7-bit character set (US7ASCII ?)

1* select name,value$ from sys.props$

NAME                           VALUE$
------------------------------ ----------------
DICT.BASE                      2
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_DATE_FORMAT                DD-MON-YY
NLS_DATE_LANGUAGE              AMERICAN
NLS_CHARACTERSET               WE8ISO8859P1    <<<<<

What you need is an 8-bit character set (WE8DEC or WE8ISO8859P1)

Oracle tech support knows a way to fix this. You can also create a new database...

Good luck,

Roelof

R. Schierbeek, DBA
The Hague, Holland
email: bytelife@worldonline.nl http://www.worldonline.nl/~bytelife Received on Wed Jun 25 1997 - 00:00:00 CDT

Re: Upper ASCII characters - Above 126 - Newbie