When you create a text configuration object using SQL statements, you use another text configuration object as a template. Then, you alter the configuration settings and create your text index using the new text configuration.

When you create a text configuration object in Sybase Central, the Create Text Configuration Object Wizard allows you to configure settings during creation.

To create a text configuration object (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute a CREATE TEXT CONFIGURATION statement.

   For example, the following statement creates a text configuration object called myTxtConfig using the default_char text configuration object as a template:

   CREATE TEXT CONFIGURATION myTxtConfig FROM default_char;

To create a text configuration object (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. Right-click Text Configuration Objects and choose New » Text Configuration Object.

3. Follow the instructions in the Create Text Configuration Object Wizard.

   The new text configuration object appears in the Text Configuration Objects pane.

See also

• Full text searching
• Text configuration object settings
• Example text configuration objects
• View text configuration objects in the database
• CREATE TEXT CONFIGURATION statement
• ALTER TEXT CONFIGURATION statement
• Default text configuration objects