SAP 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 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. We strongly suggest 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.