DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: character set

  1. #1
    Join Date
    May 2002
    Posts
    5
    Hi !

    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!

    Ruperto

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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]
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2002
    Posts
    5
    Hi again,

    I want to see the doumentation in which is described
    set / superset. Does anybody know where I can find it?

    Ruperto

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Check Metalink Note 119164.1: Changing Database Character Set - Valid Superset Definitions.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width