Previous Topic: -294 - INVALID MIXED DATA IN VALUE ASSIGNED TO column_nameNext Topic: -297 - INVALID MIXED DATA IN LIKE PATTERN


-296 - INVALID MIXED DATA IN COLUMN column_name

Explanation

The data in column_name contains shift codes for mixed data but does not contain valid mixed data. Valid mixed data requires paired shift codes and an even number of bytes for any DBCS string.

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

User Response

Modify the column to contain valid mixed or SBCS data.