In this blog post, let’s learn about the error message “3179 Collation name1 is not defined on the character set name2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3179 Collation name1 is not defined on the character set name2.
Reason for the Error
You attempted to use a collation name that is not defined on the character set. A valid collation name is required.
Solution
Correct the syntax and resubmit