Character Set Migration

Migrate your existing database to AL32UTF8

Any Single Byte Characterset (like US7ASCII, WE8DEC)

In general :

= The DMU tool is considered more user-friendly, can do the conversion without exp/imp and is easier when data needs correction and when downtime is limited.

= Full exp/imp into a new AL32UTF8 DB is noramlly used when migration to a new server/OS or when downtime is not huge issue.

= csscan / csalter (10g/11g) or Alter Database Character Set (8i/9i) / partial exp/imp is normally preferred by people who like to script things and when downtime is limited.

Subsets and Supersets

Subset  Superset

US7ASCII
UTF8  AL32UTF8

Current Character Set    New Character Set    New Character Set is strict superset?  
US7ASCII             WE8ISO8859P1       yes  
US7ASCII             ALT24UTFFSS        yes  
US7ASCII             UTF8           yes

ref : https://oracle-base.com/articles/10g/character-set-migration

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s