Text configuration objects and database options

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, the text configuration object and all its dependent text indexes.

  2. Drop the default text configuration object that you used to create the text configuration object and all its dependent text indexes.

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

  4. Create a text configuration object.

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

Note

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

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0