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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data » Text configuration objects


Database options and text configuration objects

When a text configuration object is created, the current settings for the date_format, time_format, and timestamp_format database options are stored with the text configuration object. This is because these settings affect string conversions when creating and refreshing the text indexes that depend on the text configuration object.

Storing the settings with the text configuration object allows you change the settings for these database options without causing a change to the format of data stored in the dependent text indexes.

If you want to change the format of the strings representing the dates and times in a text index, you must do the following:

  1. Drop the text index and text configuration object.

  2. Change the database options to the format you want.

  3. Create a text configuration object.

  4. Create a text index using the new text configuration object.


The conversion_error option must be set to ON when creating or refreshing a text index.

See also