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@(protected):
> 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@(protected)                              
>         on.com>                                   To
>         Sent by:            <genegurevich@(protected)
>         oracle-l-bounce@(protected)"              
>         reelists.org         <oracle-l@(protected)>        
>                                                 cc
>                                                  
>         04/26/2006 02:27                         Subject
>         PM                RE: UK characters            
>                                                  
>                                                  
>         Please respond to                              
>         ineyman@(protected)                              
>             n.com                                  
>                                                  
>                                                  
>
>
>
>
> Lookup NLS_CURRENCY
>
> -----Original Message-----
> From: oracle-l-bounce@(protected)
> [mailto:oracle-l-bounce@(protected)
> genegurevich@(protected)
> 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