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 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Steve Farmer Sent: Martes, 30 de Agosto de 2005 07:13 a.m. To: oracle-l@xxxxxxxxxxxxx Subject: Displaying £ symbol (pound sterling) Oracle 10G Hi, I am having problems storing and retrieving the £ (pound sterling) symbol ... I can store it as £ but it comes back as # ! If I change NLS_TERRITORY to 'UNITED KINGDOM" the currency symbol comes back as # I think I may need to change the character set of the DB, has anyone had any experience with this? Regards Steve -- ------------------------------------------------- Nearly all men can stand adversity, but if you want to test a man's character, give him power. -Abraham Lincoln, U.S. president (1809-1865) Support free speech; visit http://www.efa.org.au/ Heads Together Software Pty Ltd http://www.hts.com.au Email: hts@xxxxxxxxxx Tel: +44 7985 602 102 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l