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.
Built-in character sets

Built-in character sets

The ASCII character set is the default character set that is used if you do not specify the CHAR_SET index parameter in the CREATE INDEX statement. The ASCII character set includes the numbers 0 through 9, the uppercase letters A through Z, and the lowercase letters a through z. All lowercase letters are mapped internally to uppercase, which means that searches that use the ASCII character set are not case sensitive.

The ISO and OVERLAP_ISO character sets extend the ASCII character set by including many international characters. The OVERLAP_ISO character set maps similar international characters to a single ASCII character.