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