Creates a text configuration object.
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. See Default text configuration objects.
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 and their settings in the database, query the SYSTEXTCONFIG system view. See SYSTEXTCONFIG system view.
Must have DBA or RESOURCE authority.
All text configuration objects have PUBLIC access. Any user with permission to create a text index can use any text configuration object.
Automatic commit
SQL/2003 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; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |