Where can i find what character set is a subset from another character set?
I want to change the actual character set to a new which includes the Euro symbol and I couldn't find any documentation in which is described which character sets are subset of others.
On one database i want to migrate from WE8ISO8859P1
to WE8ISO8859P15 ; and on another database from WE8ISO8859P9 to WE8ISO8859P15.
Does anybody know where i can find such information?
Thanks in advance!
05-23-2002, 07:06 AM
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]
05-23-2002, 10:48 AM
I want to see the doumentation in which is described
set / superset. Does anybody know where I can find it?
05-24-2002, 03:37 AM
Check Metalink Note 119164.1: Changing Database Character Set - Valid Superset Definitions.