Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Excalibur Text Search DataBlade® Module User's GuideThese topics describe the module and how to access and use its components.
AppendixesThis section contains additional reference information.
Character setsWhen you create an etx index, you specify the character set the search engine uses by setting the CHAR_SET index parameter. The value you specify determines which characters in your text data are indexed and which are treated as white space.

Character sets

When you create an etx index, you specify the character set the search engine uses by setting the CHAR_SET index parameter. The value you specify determines which characters in your text data are indexed and which are treated as white space.

HCL OneDB™ provides three built-in character sets: ASCII, ISO, and OVERLAP_ISO. You can also define your own character sets if these character sets are inadequate for your particular text.

You cannot change the setting of the CHAR_SET parameter after you create the index unless you first drop and then recreate the index. If you do not specify a setting for CHAR_SET, the text search engine uses the ASCII character set by default.

This section contains a complete description of the following three built-in character sets:

ASCII
ISO
OVERLAP_ISO

The last section of this section contains a 16 x 16 mapping of all the characters in the ISO 8859-1 character set. You might want to use this mapping as a reference when you define your own character set.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.