HPE NonStop SQL/MX Error – 3212 Minimum length of LONG VARBINARY is value.

Data 15 Views 1 Min Read

In this blog post, let’s learn about the error message “3212 Minimum length of LONG VARBINARY is value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3212 Minimum length of LONG VARBINARY is value.

Reason for the Error

You attempted a CREATE TABLE table name (columnname long varbinary(N)) where N < current MIN_LONG_VARCHAR_DEFAULT_SIZE setting.

Solution

Increase the CREATE TABLE statement’s long varbinary column width N or decrease the current MIN_LONG_VARCHAR_DEFAULT_SIZE setting and resubmit

Tags: