CREATE TEXT CONFIGURATION Statement

Syntax

CREATE TEXT CONFIGURATION [ owner.]new-config-name 
   FROM [ owner.]existing-config-name

Examples

Example 1 – Create a text configuration object, max_term_sixteen, using the default_char text configuration object, then use ALTER TEXT CONFIGURATION to change the maximum term length for max_term_sixteen to 16:
```
CREATE TEXT CONFIGURATION max_term_sixteen FROM default_char;
```
```
ALTER TEXT CONFIGURATION max_term_sixteen MAXIMUM TERM LENGTH 16;
```

Usage

Use CREATE TEXT CONFIGURATION to create a text configuration object.

Create a text configuration object using another text configuration object as a template, then alter the options as needed using the ALTER TEXT CONFIGURATION statement.

To view the list of all text configuration objects and their settings in the database, query the SYSTEXTCONFIG system view.

FROM clause – specifies the name of a text configuration object to use as the template for creating the new text configuration object. The names of the default text configuration objects are default_char and default_nchar. Only default_char is supported for SAP Sybase IQ tables; default_nchar is supported only on SQL Anywhere tables.

Side Effects:

Automatic commit.

Permissions

Text configuration object to be owned by self –

Requires CREATE TEXT CONFIGURATION system privilege.

Text configuration object to be owned by any user – Requires one of:

CREATE ANY TEXT CONFIGURATION system privilege.
CREATE ANY OBJECT system privilege.

All text configuration objects have PUBLIC access. Any user with privilege to create a TEXT index can use any text configuration object.