Currency sign ASCII value 164 ¤

From: Häkan Latva <kalle_at_nospam.com>
Date: Mon, 27 Feb 2006 12:00:19 GMT
Message-ID: <nRBMf.23081$_k2.395629@news2.nokia.com>

I am trying to insert a currency sign to my database (we8dec character set).

I have difficulties to it as an insert from my windows terminal sqlplus session.

How I can verify it is there because I did a test and SQL> insert into test values ('¤','aaa');

1 row created.

SQL> insert into test values (ascii('164'),'bbb');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test
  2 ;

COL1

---

COL2

---

¿
aaa

49
bbb

rgds
HL Received on Mon Feb 27 2006 - 06:00:19 CST