Creates a text configuration object.

Syntax

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

Parameters

Remarks

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, including their settings, query the SYSTEXTCONFIG system view. See SYSTEXTCONFIG system view.

Permissions

Must have DBA or RESOURCE authority.

Side effects

Automatic commit

See also

• Full text search
• End-to-end example of full text searching statements
• Creating text configuration objects
• ALTER TEXT CONFIGURATION statement
• DROP TEXT CONFIGURATION statement
• CREATE TEXT INDEX statement
• ALTER TEXT INDEX statement
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE TEXT INDEX statement
• sa_refresh_text_indexes system procedure

Standards and compatibility

Example

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;