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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data

 

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
Create a text configuration object
Alter a text configuration object
Database options and text configuration objects
View text configuration objects in the database
Example text configuration objects