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