In this blog post, let’s learn about the error message “3159 If you intended name to be a character set specifier for a character string literal, you must remove the spaces in front of the single quote delimiter.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3159 If you intended name to be a character set specifier for a character string literal, you must remove the spaces in front of the single quote delimiter.
Reason for the Error
You apparently specified name as a character set specifier (for example, KANJI), but you placed a space in front of the single quote delimiter, which is not supported. For example,
_KANJI ‘xyz’
causes this error.
_KANJI’XYZ’
does not.
Solution
Correct the syntax and resubmit