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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Full text search


How to manage text configuration objects

A text configuration object controls what terms go into a text index when it is built or refreshed, and how a full text query is interpreted. The settings for each text configuration object are stored as a row in the ISYSTEXTCONFIG system table.

When the database server creates or refreshes a text index, it uses the settings for the text configuration object specified when the text index was created. If you did not specify a text configuration object when creating the text index, the database server chooses one of the default text configuration objects, based on the type of data in the columns being indexed. SQL Anywhere provides two default text configuration objects. See Example text configuration objects.

To view settings for existing text configuration objects, query the SYSTEXTCONFIG system view. See SYSTEXTCONFIG system view.

Text configuration object settings
How to create a text configuration object
How to alter a text configuration object
Text configuration objects and database options
How to view text configuration objects in the database
Example text configuration objects