HPE NonStop SQL/MX Error – 3213 Maximum length of LONG VARCHAR is value.

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

Error Message

3213 Maximum length of LONG VARCHAR is value.

Reason for the Error

You attempted a CREATE TABLE table name (columnname long varchar(N)) where N > current MAX_LONG_VARCHAR_DEFAULT_SIZE setting.

Solution

Decrease the CREATE TABLE statement’s long varchar column width N or increase the current MAX_LONG_VARCHAR_DEFAULT_SIZE setting and resubmit