HPE NonStop SQL/MX Error – 1239 The character set used for string literals in VIEW must be ISO88591.

Data 17 Views 1 Min Read

In this blog post, let’s learn about the error message “1239 The character set used for string literals in VIEW 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

1239 The character set used for string literals in VIEW must be ISO88591.

Reason for the Error

You specified a literal with a character set other than ISO88591 in the text of a create view statement.

Solution

Specify only ISO88591 literals in the command

Tags: