Schema migration from DB WE8ISO8859P15 to DB WE8MSWIN1252
Hi all,
i have to migrate 1 schema (with expdp/impdp) from:
DB Oracle 11.2 (on IBM AIX)
CharSet: WE8ISO8859P15
to new:
DB Oracle 19.25 (on Windows Server 2022)
CharSet: WE8MSWIN1252
After reading several documents on the Oracle Support site i understand that all characters included in the WE8ISO8859P15 character set are defined in WE8MSWIN1252, but NOT with the same codepoint, that means WE8MSWIN1252 is NOT a binary or "strict" superset of WE8ISO8859P15.
Indeed, the following message is returned during import Data Pump:
………
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set