US7ASCII and WE8ISO8859P1 blues

From: Gijsie <gijs.de.wolff_at_beheervisie.nl>
Date: Thu, 8 Apr 2004 16:37:44 +0200
Message-ID: <407563ba$0$559$e4fe514c@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 Received on Thu Apr 08 2004 - 09:37:44 CDT