Each row in the SYSTEXTCONFIG system view describes one text configuration object, for use with the full text search feature. The underlying system table for this view is ISYSTEXTCONFIG.
For more information about what each configuration setting means, see Text configuration object settings.
For more information about the full text search feature, see Full text search.
|Column name||Data type||Description|
|object_id||UNSIGNED BIGINT||The object ID for the text configuration object.|
|creator||UNSIGNED INT||The creator of the text configuration object.|
|term_breaker||TINYINT||The algorithm used to separate a string into terms or words. Values are 0 for GENERIC and 1 for NGRAM. With GENERIC, any string of one or more alphanumeric characters separated by non-alphanumerics are treated as a term. NGRAM is for approximate matching or for documents that do not use a whitespace to separate terms.|
|stemmer||TINYINT||For internal use only.|
The minimum length, in characters, allowed for a term. Terms that are shorter than min_term_length are ignored.
The MINIMUM TERM LENGTH setting is only meaningful for the GENERIC term breaker. For NGRAM text indexes, the setting is ignored.
For GENERIC text indexes, the maximum length, in characters, allowed for a term. Terms that are longer than max_term_length are ignored.
For NGRAM text indexes, this is the length of the n-grams into which terms are broken.
|collation||CHAR(128)||For internal use only.|
|text_config_name||CHAR(128)||The name of the text configuration object.|
|prefilter||LONG VARCHAR||The function and library name for an external prefilter library.|
|postfilter||LONG VARCHAR||For internal use only.|
|char_stoplist||LONG VARCHAR||Terms to ignore when performing a full text search on CHAR columns. These terms are also omitted from text indexes. This column is used when the text configuration object is created from default_char.|
|nchar_stoplist||LONG NVARCHAR||Terms to ignore when performing a full text search on NCHAR columns. These terms are also omitted from text indexes. This column is used when the text configuration object is created from default_nchar.|
|external_term_breaker||LONG VARCHAR||The function and library name for an external term breaker library.|
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|