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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 08 Apr 2004 18:06:44 +0200
Message-ID: <l2ua70dde8emum2qhicmdd9heveq2ha10d@4ax.com>


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
Received on Thu Apr 08 2004 - 11:06:44 CDT

Original text of this message

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