Re: US7ASCII and WE8ISO8859P1 blues

On Thu, 8 Apr 2004 16:37:44 +0200, "Gijsie" <gijs.de.wolff_at_beheervisie.nl> wrote:

>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
>

Incorrect NLS_LANG in the registry. Checkout your v$nls_session_parameters or select userenv('LANG') from dual;

--
Sybrand Bakker, Senior Oracle DBA