In this blog post, let’s learn about the error message “3217 Character set name is not allowed in the function-name function.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3217 Character set name is not allowed in the function-name function.
Reason for the Error
You specified KANJI or KSC5601 character expressions to function LOWER, LCASE, UPPER, UPSHIFT, or UCASE.
Solution
Do not use KANJI or KSC5601 character expressions in these functions