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


Example text configuration objects

For in-depth descriptions of text configuration object settings and how they impact the contents of a text index and the results returned when querying a text index, see Text configuration object settings.

For a list of all text configuration objects in the database and the settings they contain, query the SYSTEXTCONFIG system view (for example, SELECT * FROM SYSTEXTCONFIG). See SYSTEXTCONFIG system view.

You can test how a text configuration object would break a string into terms using the sa_char_terms and sa_nchar_terms system procedures. See sa_char_terms system procedure, and sa_nchar_terms system procedure.

 Default text configuration objects
 Example text configuration objects
 Example CONTAINS string interpretations