Re: Upper ASCII characters - Above 126 - Newbie

Hi Roelof,

Thanks for the answer, and yes I checked just now, and i do have the US7ASCII set...are you implying that Oracle Tech support know of a way to fix it without creating a new database ?

Do you realise that one can actually add characters higher than 127 into this DB, but that you need to use the chr() to do it ?

I was hoping there was something in the SQL*Net layer I could tweak to fix this problem...

R.Schierbeek wrote:
>
> Werner <werner.smit_at_baps.com> schreef in artikel
> <33AB78E1.35B0_at_baps.com>...
> >
> > 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$
> ------------------------------ ----------------
> 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...
>
> R. Schierbeek, DBA
> The Hague, Holland
> email: bytelife@worldonline.nl http://www.worldonline.nl/~bytelife
  Received on Fri Jun 27 1997 - 00:00:00 CDT