In this blog post, let’s learn about the error message “20245 An invalid character set was specified. Column column-name is part of the partitioning key and must be defined with the character set ISO88591.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20245 An invalid character set was specified. Column column-name is part of the partitioning key and must be defined with the character set ISO88591.
Reason for the Error
You specified a literal, with a character set other than ISO8859, for column column-name, which is part of the partition key.
Solution
Partition key columns must be defined with character set ISO88591