CREATE TEXT CONFIGURATION statement

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

FROM clause Specify the name of a text configuration object to use as the template for creating the new one. The names of the default text configuration objects are default_char and default_nchar.
When you create a text configuration object, the database options that affect how date and time values are converted to strings are copied from the default_char and default_nchar text configuration object templates.

You create a text configuration object using another text configuration object as a template and then alter the options as needed using the ALTER TEXT CONFIGURATION statement.

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

You must have the CREATE TEXT CONFIGURATION system privilege to create text configurations objects owned by you. You must have the CREATE ANY TEXT CONFIGURATION or CREATE ANY OBJECT system privilege to create text configuration objects owned by others.

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

Automatic commit

SQL/2008 Vendor extension.

The following CREATE TEXT CONFIGURATION statement creates a text configuration object, max_term_sixteen, using the default_char text configuration object. The subsequent ALTER TEXT CONFIGURATION statement changes 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;

CREATE TEXT CONFIGURATION statement

Syntax

Parameters

Remarks

Privileges

Side effects

See also

Standards and compatibility

Example