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 searching.
|Column name||Column 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||CHAR(128)||For internal use only.|
|postfilter||CHAR(128)||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.|
PRIMARY KEY (object_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id ) MATCH UNIQUE FULL
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|