Text Configuration Object Properties window: General tab

This tab has the following components:

Name   Shows the name of the text configuration object.

Type   Shows the type of object.

Owner   Shows the database user who owns the object.

Term breaker   Select one of the following algorithms to use for separating column values into terms:

  • Generic   The Generic algorithm treats as a term any string of one or more alphanumerics, separated by non-alphanumerics.

  • N-gram   The n-gram algorithm breaks the strings into n-grams. An n-gram is an n-character substring of a larger string. N-grams are useful for approximate matching or for documents that do not use a whitespace to separate terms.

Minimum term length   Specify the minimum length, in characters, of terms allowed in the text index. Terms that are shorter than this setting are ignored when building or refreshing the text index.

Maximum term length   Specify the maximum length, in characters, of terms allowed in the text index. Terms that are longer than this setting are ignored when building or refreshing the text index.

Collation sequence   Shows the database collation that the text configuration object uses.

Comment   Provides a place for you to type a text description of the text configuration object.

See Altering text configuration objects.