HPE NonStop SQL/MX Error – 1401 The default value of column column-name contains characters that cannot be converted to ISO_MAPPING ‘character-set’.

In this blog post, let’s learn about the error message “1401 The default value of column column-name contains characters that cannot be converted to ISO_MAPPING ‘character-set’.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1401 The default value of column column-name contains characters that cannot be converted to ISO_MAPPING ‘character-set’.

Reason for the Error

Unable to convert the default value of column column-name from UCS2 to the ISO_MAPPING character-set during the generation of an internal query while processing a DDL command.

Solution

None