Changing US7ASCII TO WE8ISO8859P1 in 8i, 9i, 10g and 11g
(Doc ID 1963942.1)
Last updated on APRIL 24, 2019
Oracle Database - Standard Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 11.2] Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2016***
To provide a guide to change the NLS_CHARACTERSET from US7ASCII to WE8ISO8859P1
We strongly advice to follow this note also when using export/import from an US7ASCI to a WE8ISO8859P1 database.
The current NLS_CHARACTERSET is seen in NLS_DATABASE_PARAMETERS.
select value from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';
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 )
For non-Unicode character sets the best choice are xx8MSWIN125x character sets, even if the database itself runs on an Unix platform. The reason is simply that the majority of the clients are windows based systems, hence the best non-Unicode characterset for a database is a characterset that can store all the characters known by those clients, which means an xx8MSWIN125x characterset. <Note 555823.1> Changing from US7ASCII or WE8ISO8859P1 to WE8MSWIN1252 in 8i, 9i, 10g and 11g.
Any DBA wanting to change the current NLS_CHARACTERSET from US7ASCII to WE8ISO8859P1 in 8i, 9i, 10g and 11g.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!