=?iso-8859-1?Q?RE:_Displaying_£_symbol__(pound_sterling)_Oracle_1? =?iso-8859-1?Q?0G?Date: Tue, 30 Aug 2005 11:34:31 -0400

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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: