Thanks for your help and input below.
Our officess are in London England.
The database character set and nchar_ characterset was set to we8is08859p1.
The database is oracle 8i.6.
When we enter #(pound) in sqlplus it prints to the screen as # and inserts # in the db instead of #(pound). I noticed that
the nls env variable is ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
rather than ORA_NLS3=$ORACLE_HOME/ocommon/nls/admin/data
, is that why we are having problems entering the #(pound) sign? Or do I just need to change the nls_currency
value from $ to #(pound).