Hi Gabriel,
I had not thought of the ASCII value, however I get
SQL> select ascii('£') from dual;
ASCII('??') ----------- 191
SQL> select chr(191) from dual;
C - ?
SQL> select chr(156) from dual;
C - ?
So it seems that something still needs to be changed.
What character set is your DB using ?
I will try it in a php script which sends an email and see what happens !
Regards Steve At 11:43 AM -0500 30/8/05, Aragon, Gabriel (GE Commercial Finance) wrote:
maybe you should change your approach to solve this, I would use a numeric data type to store the ascii for the symbol and just make the conversion as required..
sql> select ascii('£') from dual;
ASCII('î') ---------- 156
sql> create table money (quantity number, currency number);
Table created.
sql> insert into money values (100, 156);
1 row created.
sql> select quantity, chr(currency) from money;
QUANTITY C ---------- - 100 £
regards, GAP