Extended code page support

HCL Compass provides extended code page support.

The following code page extensions are included in HCL Compass:
  • Support for storing non-English, non-ASCII data in Compass schema repositories and user databases on Linux™ and the UNIX™ system, and extended support for these features on Windows™ systems.
  • Support for using the product in mixed character set deployments.
  • Localization for additional languages.
  • Extended graphical user interface (GUI) support to configure and use code pages in the Maintenance Tool, Designer, Export Tool, Package wizard, and User Administration Tool.

HCL Compass processes data in Unicode, and its applications use the Compass data code page to write to its databases. Compass data is processed by using the local character set. Even when the Compass data code page does not match the local character set, Compass applications can now connect to the HCL Compass database in read/write mode. In previous versions, write operations were not allowed unless the local character set matched the Compass data code page.

Support for additional code pages

HCL Compass supports additional languages and locales. The product now supports the following Microsoft™ Windows code pages on all supported platforms:

  • 932 (Japanese SJIS)
  • 936 (Simplified Chinese)
  • 949 (Korean)
  • 950 (Traditional Chinese)
  • 1250 (Eastern Europe)
  • 1251 (Cyrillic)
  • 1252 (Latin-1)
  • 1253 (Greek)
  • 1254 (Turkish)
  • 1255 (Hebrew)
  • 1257 (Baltic)
  • 20127 (ASCII)

Safe ShiftJIS is also supported. See Supported data code pages and Locales associated with supported data code pages for details on supported languages and locales.

HCL Compass version 7.1.1 adds support for UTF-8 (8-bit Unicode Transformation Format) and data code page 65001 for the DB2® and Oracle database sets. See Supported data code pages and Locales associated with supported data code pages for details and limitations.

Extended GUI support

Options are available in Compass to perform the following tasks:
  • Use the Maintenance tool to set or change the Compass Data Code Page setting for a schema repository or connection to any of the supported Compass data code pages.
  • Use the User Administration tool to specify file encoding when exporting user and group information,
  • Use the Designer to create a new user database, selecting from all schemas defined in the schema repository. Newly created schema repositories that use data code pages 932 or 60932 (Japanese), or 936 (Simplified Chinese) contain matching localized versions as well as ASCII versions of every schema included with Compass. Other schema repositories contain only ASCII schema versions. Localized schema version names reflect the language and the package version numbers.
  • Use the Package wizard to install packages in a schema, or the Package Upgrade wizard to upgrade packages in a schema, selecting from a list of the latest available packages compatible with the Compass data code page of the schema repository. In a schema repository whose data code page is 65001 (UTF-8), the Package Upgrade wizard displays all localized and ASCII versions of every package. In a schema repository whose data code page is 932 or 60932 (Japanese), or 936 (Simplified Chinese), the Package Upgrade wizard displays the latest matching localized versions and ASCII versions of every package. In other schema repositories, the wizard display only ASCII package versions.
  • Use the Export tool to select the file encoding when exporting query results.
  • Select the file encoding when exporting a profile.