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.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
Right-click Text Configuration Objects and choose New » Text Configuration Object.
Follow the instructions in the Create Text Configuration Object Wizard.
The new text configuration object appears in the Text Configuration Objects pane.
Connect to the database as a user with DBA authority.
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; |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |