Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: US7ASCII and WE8ISO8859P1 blues
"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