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.
OverviewThis section provides an overview of the module.
Character setsCharacter sets define the characters that are indexed when an etx index is built on a column that contains text documents. Any character in the text document not found in the specified character set is treated as white space in the index. The character is not changed in the text document itself.

Character sets

Character sets define the characters that are indexed when an etx index is built on a column that contains text documents. Any character in the text document not found in the specified character set is treated as white space in the index. The character is not changed in the text document itself.

Specify a character set by setting the CHAR_SET index parameter to the name of the character set when you create an etx index with the CREATE INDEX statement.

The module provides three built-in character sets: ASCII, ISO, and OVERLAP_ISO. You can also define your own character set if the ones provided are not adequate for your text documents.

Important: Different character sets support different numbers of characters in an index. For a character set that supports more characters, fewer characters are searched in a clue word, and vice versa.

The following sections describe the built-in character sets and explain when and how to create your own.