The TERM BREAKER setting specifies the algorithm to use for breaking strings into terms. The choices are GENERIC for storing terms, or NGRAM for storing n-grams. For GENERIC, you can use the built-in term breaker algorithm, or an external term breaker.
The following table explains the impact that the value of TERM BREAKER has on text indexing and on how query strings are handled:
|Text indexes||Query strings|
When parsing a CONTAINS query, the database server extracts keywords and special characters from the query string and then
applies the term breaker algorithm to the remaining terms. For example, if the query string is
If not defined, the default for TERM BREAKER is taken from the setting in the default text configuration object. If a term breaker is not defined in the default text configuration object, the internal term breaker is used.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|