Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


conversion_error option [compatibility]

Controls the reporting of data type conversion failures on fetching information from the database.

Allowed values

On, Off




This option controls whether data type conversion failures, when data is fetched from the database or inserted into the database, are reported by the database as errors (conversion_error set to On) or as a warning (conversion_error set to Off).

When conversion_error is set to On, the SQLE_CONVERSION_ERROR error is generated. If the option is set to Off, the warning SQLE_CANNOT_CONVERT is produced.

If conversion errors are reported as warnings only, the NULL value is used in place of the value that could not be converted. In embedded SQL, an indicator variable is set to -2 for the column or columns that cause the error.