4 Replies Latest reply: Jul 12, 2012 6:36 PM by Sergiusz Wolicki-Oracle RSS

    character set conversion

    915922
      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
          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
            Recommended is AL32UTF8

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

            HTH
            Srini
            • 3. Re: character set conversion
              orafad
              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
                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