Vertica Analytics Platform Version 9.2.x Documentation

SET STANDARD_CONFORMING_STRINGS

Treats backslashes as escape characters for the current session.

Syntax

SET STANDARD_CONFORMING_STRINGS TO { ON | OFF }

Parameters

ON

Makes ordinary string literals ('...') treat back slashes (\) literally. This means that back slashes are treated as string literals, not escape characters. (This is the default.)

OFF

Treats back slashes as escape characters.

Privileges

None

Notes

  • This statement works under vsql only.
  • When standard conforming strings are on, Vertica supports SQL:2008 string literals within Unicode escapes.
  • Standard conforming strings must be ON to use Unicode-style string literals (U&'\nnnn').

To set conforming strings across all sessions (permanently), use theStandardConformingStrings as described in Internationalization Parameters in the Administrator's Guide.

Examples

The following example shows how to turn off conforming strings for the session.

=> SET STANDARD_CONFORMING_STRINGS TO OFF;

The following command lets you verify the settings:

=> SHOW STANDARD_CONFORMING_STRINGS;
            name             | setting
-----------------------------+---------
 standard_conforming_strings | off
(1 row)

The following example shows how to turn on conforming strings for the session.

=> SET STANDARD_CONFORMING_STRINGS TO ON;