Is WE8ISO8859P1 8-bit?

Is WE8ISO8859P1 8-bit?

Post by Luddi » Sun, 31 Dec 1899 09:00:00



We have an application on Oracle 8.1.5. The setting of the NLS_LANG is
"AMERICAN_AMERICA.WE8ISO8859P1". This is also confirmed by the SQL:

SQL> select userenv('LANGUAGE') "Language" from dual;

Language
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1

I used to think that WE8 = Western European 8 bit coding. But when I write
to a varchar2 column, the MSB bit is always stripped off. The accented
character '' (hex C8) becomes 'H' (hex 48). Just what should I do to have
all the 8 bits character set coding?

TIA

 
 
 

Is WE8ISO8859P1 8-bit?

Post by Sybrand Bakke » Sun, 31 Dec 1899 09:00:00


Make sure the same NLS_LANG setting exists on *any* client
and use 8-bit charactersets.

Hth,

Sybrand Bakker, Oracle DBA



Quote:> We have an application on Oracle 8.1.5. The setting of the NLS_LANG is
> "AMERICAN_AMERICA.WE8ISO8859P1". This is also confirmed by the SQL:

> SQL> select userenv('LANGUAGE') "Language" from dual;

> Language
> ----------------------------------------------------
> AMERICAN_AMERICA.WE8ISO8859P1

> I used to think that WE8 = Western European 8 bit coding. But when I write
> to a varchar2 column, the MSB bit is always stripped off. The accented
> character '' (hex C8) becomes 'H' (hex 48). Just what should I do to have
> all the 8 bits character set coding?

> TIA


 
 
 

Is WE8ISO8859P1 8-bit?

Post by Luddi » Sun, 31 Dec 1899 09:00:00


It really was the client. Thanks for the help.


>Make sure the same NLS_LANG setting exists on *any* client
>and use 8-bit charactersets.

>Hth,

>Sybrand Bakker, Oracle DBA



>> We have an application on Oracle 8.1.5. The setting of the NLS_LANG is
>> "AMERICAN_AMERICA.WE8ISO8859P1". This is also confirmed by the SQL:

>> SQL> select userenv('LANGUAGE') "Language" from dual;

>> Language
>> ----------------------------------------------------
>> AMERICAN_AMERICA.WE8ISO8859P1

>> I used to think that WE8 = Western European 8 bit coding. But when I
write
>> to a varchar2 column, the MSB bit is always stripped off. The accented
>> character '' (hex C8) becomes 'H' (hex 48). Just what should I do to
have
>> all the 8 bits character set coding?

>> TIA