HPE NonStop SQL/MX Error – 1240 The character set for a PARTITION KEY column must be ISO88591.

In this blog post, let’s learn about the error message “1240 The character set for a PARTITION KEY column must be ISO88591.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1240 The character set for a PARTITION KEY column must be ISO88591.

Reason for the Error

You specified a literal with a character set other than ISO88591 as a partition key.

Solution

Specify only ISO88591 literals as partition keys