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.
The etx index parametersThis section describes the index parameters that can be used to customize an etx index. You specify index parameters in the USING clause of the CREATE INDEX statement.
The CHAR_SET parameterUse the CHAR_SET index parameter to specify which characters in your text data are indexed. Characters that are not indexed are treated as white space.
Built-in character sets

Built-in character sets

The ASCII setting means that only the alphanumeric characters 0 through 9, A through Z, and a through z are indexed. If the CHAR_SET index parameter is not specified when you create an etx index, the ASCII table is used by default.

When using the ASCII setting, words that contain international characters might actually be indexed as multiple words. For example, the word caon, if indexed with the ASCII character set, is indexed as two words, ca and on, because the non-indexed character is treated as white space.

The ISO setting means that both alphanumeric characters and ISO Latin-1 alphabetic characters are indexed. This 68-character set is to be used to index data that might contain international characters from the ISO Latin-1 set.

The OVERLAP_ISO setting means that the same character set as the ISO setting is indexed, but similar-looking characters are grouped together so that a word matches as long as corresponding letters are from the same group.