In this blog post, let’s learn about the error message “1238 The character set used in TRIGGER text 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
1238 The character set used in TRIGGER text must be ISO88591.
Reason for the Error
You specified a literal with a character set other than ISO88591 in the text of a create trigger statement.
Solution
Specify only ISO88591 literals in the command
