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: US7ASCII and WE8ISO8859P1 blues

Re: US7ASCII and WE8ISO8859P1 blues

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 8 Apr 2004 17:39:23 +0200
Message-ID: <4075721b$0$22886$626a14ce@news.free.fr>

"Gijsie" <gijs.de.wolff_at_beheervisie.nl> a écrit dans le message de news:407563ba$0$559$e4fe514c_at_news.xs4all.nl...
> Hi,
>
> I have the following problem. I have a 8.1.7 Oracle server with a
> WE8ISO8859P1 characterset. The server behaves however as if she uses
> US7ASCII.
>
> Whatever can cause this behaviour. The following SQL and replies will
> demonstrate my problem:
>
> Q: select 'h' from dual;
> A: h
>
> Q: select chr(104) from dual;
> A: h
>
> Q: select 'è' from dual;
> A: h
>
> Q: select chr(232) from dual;
> A: h
>
> Since US7ASCII is a 128-charset a US7ASCII server answers chr(232) as
> chr(232-128).
> My WE8ISO8859P1-server however does exactly the same.
>
> Can anybody please explain this strange behaviour.
>
> Thanks,
> Gijs de Wolff
>
>

What is the NLS_LANG of the client?
What is the character set used by the client as OS level?

Regards
Michel Cadot Received on Thu Apr 08 2004 - 10:39:23 CDT

Original text of this message

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