Supported vendor database character sets
Each HCL Compass data code page has a corresponding character set for each supported vendor database: Oracle, DB2®, and SQL Server.
To help you choose an appropriate character set for your vendor database, Table 1 lists the supported Compass data code page values and their corresponding vendor database character set values.
HCL Compass supports the UTF-8 (8-bit Unicode Transformation Format) code page 65001. This support is limited to creating new database sets. Compass does not support converting an existing database set to the UTF-8 code page.
Compass supports the UTF-8 (8-bit Unicode Transformation Format) code page 65001.
For instructions about how to set the character set for your vendor database, see the vendor database documentation.
Code page 932 (Japanese) on Oracle
Code page 932 (Japanese) on DB2
IBM-943 is the recommended code set for Japanese SJIS data on DB2. You must configure the database management system to use the conversion table that is compatible with the Microsoft™ definition of code page 932. If this alternate character set is not used, you cannot set the Compass data code page to 932 for new schemas. Also, if you do not convert an existing DB2 database set to use the alternate conversion table, some characters in the 932 character set will be corrupted. See Alternative Unicode conversion table for CCSID 943.