Changing US7ASCII or WE8ISO8859P1 to WE8MSWIN1252 in 8i, 9i, 10g and 11g
(Doc ID 555823.1)
Last updated on FEBRUARY 26, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform.
Purpose
To provide a guide to change the NLS_CHARACTERSET from US7ASCII or WE8ISO8859P1 to WE8MSWIN1252.
We strongly advice to follow this note also when using export/import from an US7ASCII or WE8ISO8859P1 to a WE8MSWIN1252 database.
The current NLS_CHARACTERSET is seen in NLS_DATABASE_PARAMETERS.
This note is ONLY for 8i, 9i, 10g and 11g it cannot be used for Oracle RDBMS 12c For other characterset conversions and Oracle 12c please see <Note 225912.1> Changing the Database Character Set ( NLS_CHARACTERSET )
Scope
Any DBA want to change the current NLS_CHARACTERSET from US7ASCII or WE8ISO8859P1 to WE8MSWIN1252 in 8i, 9i, 10g and 11g.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!