Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data » Full text search

 

Text configuration objects

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:

Statement Description
CREATE TEXT CONFIGURATION statement Use this statement to create a text configuration object. You create text configuration objects by copying an existing one, and then altering the settings as desired.
ALTER TEXT CONFIGURATION statement Use this statement to alter the settings for a text configuration object. For example, use this statement to specify the terms to ignore when building a text index.
DROP TEXT CONFIGURATION statement Use this statement to drop a text configuration object.

Creating text configuration objects
Altering text configuration objects