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.
The conversion_error option must be set to ON when creating or refreshing a text index.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|