If you want to change the data code page of an existing Rational® ClearQuest® schema
repository, you must verify that the databases associated with that schema
repository do not contain characters that are outside the planned data code
page. You must identify and convert such characters before you change the
data code page.
The code page utility codepageutil helps you with
these tasks. It provides two commands. codepageutil test_codepg checks
which character set a database can handle. codepageutil analyze_tables locates
characters in an existing database that are not supported for a target data
code page setting, and must be converted to valid characters to ensure data
integrity.
For example, if you decided that, because there are UNIX database servers
in your
Rational ClearQuest environment,
you want to convert a
Rational ClearQuest database
from code page
932 (Japanese) to code page
60932 (Japanese with
safe Shift-JIS encoding), you can use the code page utility to perform the
following tasks:
- Determine whether changing the data code page for a Rational ClearQuest schema
repository or database will require any data conversion.
- If data conversion is necessary, estimate the amount of work required
to convert the database, by counting the number of characters in the database
that are unsupported in data code page 60932.
- If data conversion is necessary, identify the location of each character
that is unsupported for code page 60932; that is, the table, the record and
record ID, and the field name and position in the field, where each unsupported
character is located.