SET ESCAPE_STRING_WARNING
Issues a warning when a backslash is used in a string literal during the current session.
Syntax
SET ESCAPE_STRING_WARNING TO { ON | OFF }
Parameters
ON |
[Default] Issues a warning when a back slash is used in a string literal. Tip: Organizations that have upgraded from earlier versions of Vertica can use this as a debugging tool for locating backslashes that used to be treated as escape characters, but are now treated as literals. |
OFF |
Ignores back slashes within string literals. |
Privileges
None
Notes
- This statement works under vsql only.
- Turn off standard conforming strings before you turn on this parameter.
To set escape string warnings across all sessions, use the EscapeStringWarnings configuration parameter. See the Internationalization Parameters in the Administrator's Guide.
Examples
The following example shows how to turn OFF escape string warnings for the session.
=> SET ESCAPE_STRING_WARNING TO OFF;