Home
Administering
Learn how to administer the product.
Administering HCL Compass
Learn how to administer the HCL Compass.
Managing databases
Describes the different types of databases that the administrator can create and manage
Code pages and national language support
Working with HCL Compass data code pages
After you determine the appropriate HCL Compass data code page and create a vendor database instance with the corresponding vendor database character set, you can perform the tasks outlined in this topic.
Ensuring characters in database sets are supported in a HCL Compass data code page
If you are using HCL Compass for the first time, the GUI-based tools provide support to set up and manage data code pages for your schema repositories. Also, for many previous users of HCL Compass whose data code pages were set to US-ASCII, the GUI provides all required code page functionality.
Developing a data conversion strategy
Mapping unsupported characters to supported characters

Mapping unsupported characters to supported characters

If you convert the database, you must decide what to do with each unsupported character. Each unsupported character must be mapped to one or more supported characters.

For example, you are converting a database from a Latin-1 character set to ASCII. If you have German-speaking users who have entered the character "ä" into the database, you can convert the character in one of these ways:

Convert the "ä" into "a", which is the closest single character.
Convert the "ä" into "ae", which is considered equivalent in German.
If the "ä" appears in a status code in German, convert the entire status code to English.

There is no simple solution to this problem; you must choose the mappings that best fit the needs of your users.