Sybase Error – Odd length of binary data value detected on column %2 – %1

In this blog post, you’ll learn more about the Sybase Error Odd length of binary data value detected on column %2 – %1 and the reason for receiving this error

Sybase SQL Error Message

Odd length of binary data value detected on column %2 – %1

Reason for this Error

When loading hexadicimal data into BLOB, the total number of nibbles has to be an even number. If an odd number is detected, the load engine will rollback. This restriction does not apply to binary and varbinary data type.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....