A text configuration object is a set of configuration settings that control characteristics of text index data such as what terms to ignore, and the minimum and maximum length of terms to include in the index. Each text configuration object is stored as a row in the ISYSTEXTCONFIG system table.

When you create a text index, you can specify the text configuration object to use for building and refreshing the text index. If you do not specify a text configuration object when creating a text index, the database server chooses the applicable default text configuration object to use.

Two default text configuration objects, default_char and default_nchar, are automatically created in the database the first time a text index or text configuration object is created. default_nchar is used for creating text indexes when at least one column in the text index is an NCHAR column. Otherwise, default_char is the default.

When the database server builds a text index, non-text columns are automatically converted to strings in the CHAR database character set if default_char, or any CHAR text configuration object, is specified. Similarly, non-text columns are automatically converted to strings in the NCHAR database character set if default_nchar, or any NCHAR text configuration object, is specified.

Accessing text configuration object information in the database

To see a list of all configuration objects and their settings, execute the following statement:

SELECT * FROM SYSTEXTCONFIG;

See SYSTEXTCONFIG system view.

To see a list of text indexes and the text configuration objects they refer to, execute the following statement:

CALL sa_text_index_stats( );

See sa_text_index_stats system procedure.

SQL statements for managing text configuration objects

Use the following statements to manage text configuration objects: