Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center