Sybase IQ provides default text configuration objects.
The default text configuration object default_char is used with non-NCHAR data. This configuration is created the first time you create a text configuration object or TEXT index.
The text configuration object default_nchar is supported for use with NCHAR for TEXT indexes on IN SYSTEM tables; you cannot use default_nchar text configuration for TEXT indexes on Sybase IQ tables.
The table "Default text configuration settings" shows the default settings for default_char and default_nchar, which are best suited for most character-based languages. Sybase strongly recommends that you do not change the settings in the default text configuration objects.
Setting |
Installed value |
|---|---|
TERM BREAKER |
GENERIC |
MINIMUM TERM LENGTH |
1 |
MAXIMUM TERM LENGTH |
20 |
STOPLIST |
(empty) |
If you delete a default text configuration object, it is automatically re-created with default values the next time you create a TEXT index or text configuration object.