Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Querying and modifying data » Full text search » How to manage text configuration objects

 

How to create a text configuration object

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 (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to 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.

 ♦  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;
 See also