Database options and text indexes

When a text configuration object is created, the current settings for the following database options are stored for the object: date_format, time_format, timestamp_format.

These settings affect string conversions when creating and refreshing the text indexes that refer to the text configuration object.

Since the settings for these options are stored with the text configuration object, changing these database options does not affect string conversions when creating or refreshing text indexes. However, this means that if you want to change how string conversions are handled for a text index, you must:

  1. Drop the text index.
  2. Optionally drop the text configuration object.
  3. Change the database options.
  4. Create a new text configuration object.
  5. Recreate the 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
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0