This discussion is archived
4 Replies Latest reply: Jul 12, 2012 4:36 PM by Sergiusz Wolicki (Oracle) RSS

character set conversion

915922 Newbie
Currently Being Moderated
Hi

One of our customer database on 11.2.0.3.0 has been defined as US7ASCII - 7 bit

this has created problem as the db needed 8 bit

now they plan to use csscan to move from US7ASCII to WE8MSWIN1252

the query is whether to use WE8MSWIN1252 or AL32UTF8

some of the dataset is in non english, french japanese..etc

cscan report which they ran showed following

Report2: dbcheck1252.txt
Database character set US7ASCII
FROMCHAR WE8MSWIN1252
TOCHAR WE8MSWIN1252

should the FROMCHAR not be US7ASCII



thanks
  • 1. Re: character set conversion
    KSG Explorer
    Currently Being Moderated
    WE8MSWIN1252 (This is a Western European Standard, single bit characterset)
    AL32UTF8 (This is the superset of "WE8MSWIN1252" and multi bit characterset).

    If you are using global characters then go for AL32UTF8 (keep in mind it is multibit character set).
    should the FROMCHAR not be US7ASCII 
    FROMCHAR should be US7ASCII

    Regards
    KSG

    Edited by: KSG on Jul 12, 2012 4:45 PM
  • 2. Re: character set conversion
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Recommended is AL32UTF8

    http://docs.oracle.com/cd/E11882_01/server.112/e25494/create001.htm#ADMIN13343

    HTH
    Srini
  • 3. Re: character set conversion
    orafad Oracle ACE
    Currently Being Moderated
    912919 wrote:

    now they plan to use csscan to move from US7ASCII to WE8MSWIN1252
    Take note of DMU - now the recommended way to migrate to AL32UTF8 for current Database versions (11.2.0.3 and on).

    https://forums.oracle.com/forums/ann.jspa?annID=1794
    http://www.oracle.com/technetwork/products/globalization/dmu/overview/index.html

    >
    the query is whether to use WE8MSWIN1252 or AL32UTF8

    some of the dataset is in non english, french japanese..etc
    For japanese, you can't use WE8MSWIN1252. Win-1252 does not define any japanese characters.

    Also, the recommended database characterset for new installations is AL32UTF8.
    I think you should base your decision on Unicode and only if you find strong reasons against it, choose something else.
  • 4. Re: character set conversion
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    As already said, migrate to AL32UTF8 (a requirement to support French and Japanese at the same time) and use the Database Migration Assistant for Unicode (DMU) instead of CSSCAN.


    -- Sergiusz

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points