Displaying £ symbol (pound sterling) Oracle 10G

  • From: Steve Farmer <hts@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 30 Aug 2005 13:13:26 +0100

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

Other related posts:

  • » Displaying £ symbol (pound sterling) Oracle 10G