2 Replies Latest reply: Jun 1, 2012 1:25 AM by wzhang-Oracle RSS

    migrating schema from NLS_CHARACTERSET WE8MSWIN1252 to AL32UTF8

    899419
      hi,

      i have to migrate an schema from one of the DB instance with below char set

           PARAMETER     VALUE
      1     NLS_CHARACTERSET     WE8MSWIN1252
      2     NLS_NCHAR_CHARACTERSET     AL16UTF16

      to a database instance with below char set,

      1 NLS_CHARACTERSET AL32UTF8
      2 NLS_NCHAR_CHARACTERSET UTF8

      will there be any data loss after migrating the schema?
      what will be the effect?

      Thanks
      Shubhu