Re: UK characters

 From what I can recall...

You must be using a character set that supports the currency symbol in question. The default (I think) is US7ASCII - which is not helpful. Try using something like
WE8ISO8859P1 - standard Western European 8 bit character set (not sure if there's a Euro symbol in there though).

You also need to have the NLS Territory, NLS Language and NLS Characterset all set correctly for a UK environment.

If you can't convert your existing characterset, then you'll need to rebuild the DB.
There's a raft of information in the Globalization (sic) Folder under metalink - have a look at note 190574.1 to get started.

Dougie McGibbon

genegurevich_at_discoverfinancial.com wrote:
> Thanks. Igor., I looked up nls_currency on the metalink, but I can't find a
> list of acceptable values. Do you happen
> to know where it is located?
>
> thank you
>
> Gene Gurevich
>
>
>
>
> "Igor Neyman"
> <ineyman_at_perceptr
> on.com> To
> Sent by: <genegurevich_at_discoverfinancial.com
> oracle-l-bounce_at_f >, "oracle-l"
> reelists.org <oracle-l_at_freelists.org>
> cc
>
> 04/26/2006 02:27 Subject
> PM RE: UK characters
>
>
> Please respond to
> ineyman_at_perceptro
> n.com
>
>
>
>
>
>
> Lookup NLS_CURRENCY
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> genegurevich_at_discoverfinancial.com
> Sent: Wednesday, April 26, 2006 3:15 PM
> To: oracle-l
> Subject: UK characters
>
> Hello:
>
> I'm trying to let our users from UK to enter british pound into the
> database. Currently this sigh is being converted to a question mark. I
> have tried modifying nls_languate and nls_territory but without success
> and ORacle manual is not very helpful. Can someone refer me to an
> article that explains this?
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l