Previous Topic: -57 - SPECIFIED MORE COLUMNS OR VALUES THAN THE TABLE HASNext Topic: -60 - nnnn IS GREATER THAN MAXIMUM ALLOWABLE NUMBER OF COLUMNS


-58 - COLUMN aaaa DATATYPE INCOMPATIBLE WITH bbbb DATATYPE

Reason:

The data type of a value specified in an INSERT statement does not correspond to the defined data type of the destination column.

The SQLSTATE that equates to this SQL return code is 42821.

Action:

Inspect the data types of the value and destination column in question and make any necessary correction.