Sybase IQ provides the default text configuration object default_char for use with non-NCHAR data. This configuration is created the first time you create a text configuration object or TEXT index. In addition, 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.
Table 2-2 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.
