Previous Topic: -296 - INVALID MIXED DATA IN COLUMN column_nameNext Topic: -298 - INVALID MIXED DATA IN VARGRAPHIC OPERAND


-297 - INVALID MIXED DATA IN LIKE PATTERN

Explanation

The data in the like pattern 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 like pattern to contain valid mixed or SBCS data.