Running the code page utility codepageutil
If you want to change the data code page of an existing HCL Compass 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 HCL Compass environment,
you want to convert a HCL Compass 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 HCL Compass 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.