Warning 1000117

"The data to be inserted into table '%2', column '%1' cannot be converted to the datatype of the column. NULL will be inserted if the column allows NULLs."

Item Description

SQLCode

1000117L

Constant

EMSG_CANNOT_CONVERT_FOR_INSERT

SQLState

00B17

ODBC 2 State

OK

ODBC 3 State

OK

Sybase Error Code

20777

Severity Code

1

Parameter 1

The table that is being inserted to.

Parameter 2

The column that is being inserted to.

Probable cause

The database option CONVERSION_ERROR has been set to 'OFF' for this INSERT. The data to be inserted to the named column cannot be converted to the datatype of that column. If the column allows NULL, then NULL will be inserted instead.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com