NGRAM TEXT Index

NGRAM TEXT index stores the text in the column by breaking the text into n-grams of text value N, where N is the value given by a user.

You can perform a search over an NGRAM TEXT index by matching the n-grams of the text value in the CONTAINS clause of the query against the stored n-grams in the index.

NGRAM TEXT index accommodates fuzzy searching capability over the text for both European and non-European languages. For more information on fuzzy searching, see Unstructured Data Queries > NGRAM TEXT Index Searches > Fuzzy Search.

Note: NGRAM TEXT index search is mainly useful when words are misspelled. Sybase IQ does not support searches like synonyms and antonyms.

NGRAM term breaker is built on TEXT indexes, so use text configuration object settings to define whether to use an NGRAM or GENERIC TEXT index.

For more information on text configuration object settings, see SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Querying and Modifying Data > Querying Data > Text configuration objects > Text configuration object settings.

Parent topic: TEXT Indexes and Text Configuration Objects