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:

Drop the text index and text configuration object.

Change the database options to the format you want.

Create a text configuration object.

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.