Your database character set WE8ISO8859P1 cannot store the euro symbol. If you store it inside such a database, it would be altered when you transfert data between systems or Oracle export/import.

You can do conversion if the first charater set is an superset if the second one. For instance WE8ISO8859P15 -> WE8ISO8859P1 may work, not the opposite.

Addition: If you would like to be able to view the euro symbol € in SQL*Plus GUI, then you should add to the registry (to ORACLE_HOME): SQLPLUS_FONT and SQLPLUS_FONT_SIZE, so that SQLPLUS_FONT supports the Euro, for example Courier New or Lucida Console. You should also set set HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP to 1252. I just tested if it works.


[Edited by julian on 05-23-2002 at 07:11 AM]