NLS problem on AIX

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 2 Jun 1999 08:58:15 GMT
Message-ID: <01beacde$ccb8c190$2c289a0a@apollo>

I have a new db on AIX 4.3.2, Oracle 8.0.5 with character set = WE8ISO8859P1. I have some problems with the special danish characters <æøå> If I work directly on the server <æøå> becomes <fxe> when inserted into the database, however when I connect from my NT workstation, using sqlplus, everything works fine.
What might be the problem here?

Thanks
Peter

Examples:

From the 3151 terminal (or telnet) I start sqlplus :

Create table test(a varchar2(10))
insert into test(a) values('<æøåÆØÅ>')
commit
select * from test

a
---
<fxeFXE>

However if I connect from my NT through net8 everything works fine: SQL> select * from test;

A

---

<fxeFXE>

SQL> insert into test(a) values('<æøåÆØÅ>');

1 række er oprettet.

SQL> select * from test;

A

---

<fxeFXE>
<æøåÆØÅ>

SQL> commit;

Bekræftelse er udført.

Now from the server:
SQL> select * from test;

A

---

<fxeFXE>
<??????>
Received on Wed Jun 02 1999 - 03:58:15 CDT