Sybase Error – The data to update table ‘%2′, column `%1’ cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs.

In this blog post, you’ll learn more about the Sybase Error The data to update table ‘%2′, column `%1’ cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs. and the reason for receiving this error

Sybase SQL Error Message

The data to update table ‘%2′, column `%1’ cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs.

Reason for this Error

The database option CONVERSION_ERROR has been set to ‘OFF’ for this UPDATE. During UPDATE, the data to update one of the columns cannot be converted to the datatype of the column. The update number represents the number of updates made to the table which is not necessarily the row number of the table being updated. The column will be updated with NULL if the column definition allows NULLs.