Previous Topic: -564 - ONLY ONE PRIMARY KEY MAY BE DEFINEDNext Topic: -566 - INVALID HEX DIGIT IN HEX LITERAL <xxxx>--USE 0-9, A-F

SQL Codes › SQL Return Codes -1 through -999 › -565 - HEX LITERALS MUST HAVE EVEN NUMBER OF HEX DIGITS: xxx

-565 - HEX LITERALS MUST HAVE EVEN NUMBER OF HEX DIGITS: xxx

Explanation

You have specified a hexadecimal literal which has an odd number of digits. A hexadecimal literal must have an even number of hexadecimal digits.

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

User Response

Use leading zeros if necessary to make the literal have an even number of digits.