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.
| 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. |
| min_term_length | TINYINT |
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. |
| max_term_length | TINYINT |
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. |
PRIMARY KEY (object_id)
FOREIGN KEY (object_id) REFERENCES SYS.ISYSOBJECT (object_id ) MATCH UNIQUE FULL
FOREIGN KEY (creator) REFERENCES SYS.ISYSUSER (user_id)
UNIQUE INDEX (creator, text_config_name)