Creates a text configuration object.
Syntax
CREATE TEXT CONFIGURATION [ <owner>.]<new-config-name>
FROM [ <owner>.]<existing-config-name>
Parameters
(back to top)
- FROM 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. DEFAULT_CHAR is
supported for SAP IQ tables only;
DEFAULT_NCHAR is supported on SAP SQL Anywhere tables
only.
Examples
(back to top)
- Example
1 creates 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
(back to top)
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.
Permissions
(back to top)
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.