HPE NonStop SQL/MX Error – 20153 The VARCHAR varying-length can support VARCHAR data type only.

In this blog post, let’s learn about the error message “20153 The VARCHAR varying-length can support VARCHAR data type only.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20153 The VARCHAR varying-length can support VARCHAR data type only.

Reason for the Error

You specified VARCHAR for a column that is not a VARCHAR data type.

Solution

Verify your data file and resubmit