Previous Topic: -293 - PREDICATE INVALID BECAUSE HOST VARIABLE <nnn> HAS THE NULL VALUENext Topic: -296 - INVALID MIXED DATA IN COLUMN column_name


-294 - INVALID MIXED DATA IN VALUE ASSIGNED TO column_name

Explanation

The data assigned to the 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 value to contain valid mixed or SBCS data.