HPE NonStop SQL/MX Error – 20588 Invalid Character error converting string from character set charset1 to character set charset2.

In this blog post, let’s learn about the error message “20588 Invalid Character error converting string from character set charset1 to character set charset2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20588 Invalid Character error converting string from character set charset1 to character set charset2.

Reason for the Error

You specified an invalid character set.

Solution

Specify an ISO88591 character set