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
