Contents
Is it possible to migrate a character set in Oracle?
For database character set migration to be successful, both of these cases require manual intervention because Oracle Database cannot determine the character sets of the data being stored. Incorrect data conversion can lead to data corruption, so perform a full backup of the database before attempting to migrate the data to a new character set.
What are the steps in character set migration?
Database character set migration has two stages: data scanning and data conversion. Before you change the database character set, you need to identify possible database character set conversion problems and truncation of data. This step is called data scanning.
When to choose a new character set for a database?
A related topic is choosing a new character set for an existing database. Changing the database character set for an existing database is called character set migration. When you migrate from one database character set to another you must choose an appropriate character set. You should also plan to minimize data loss from the following sources:
What causes loss of data in character set migration?
Another character set migration scenario that can cause the loss of data is migrating a database that contains invalid data. Invalid data usually occurs in a database because the NLS_LANG parameter is not set properly on the client. The NLS_LANG value should reflect the client operating system code page.
How are characters stored in a character set?
For example, the specification CHAR (20) in a table definition allows 20 bytes for storing character data. When the database character set uses a single-byte character encoding scheme, no data loss occurs when characters are stored because the number of characters is equivalent to the number of bytes.
Which is higher, a legacy character set or Unicode?
Therefore, storage requirements of Unicode are usually higher than storage requirements of a legacy character set for the same language. A related topic is choosing a new character set for an existing database. Changing the database character set for an existing database is called character set migration.
What is the database character set for Oracle 10g?
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production With the Partitioning, OLAP and Data Mining options Current database character set is WE8MSWIN1252.