Internationalization Parameters

The following table describes the internationalization parameters for configuring Vertica.

Parameters Description

DefaultIntervalStyle

Sets the default interval style to use. If set to 0 (default), the interval is in PLAIN style (the SQL standard), no interval units on output. If set to 1, the interval is in UNITS on output. This parameter does not take effect until the database is restarted.

Default Value: 0

Example:

ALTER DATABASE mydb SET DefaultIntervalStyle = 1;

DefaultSessionLocale

Sets the default session startup locale for the database. This parameter does not take effect until the database is restarted.

Default Value: en_US@collation=binary

Example:

ALTER DATABASE mydb SET DefaultSessionLocale = 'en_GB';

EscapeStringWarning

Issues a warning when back slashes are used in a string literal. This is provided to help locate back slashes that are being treated as escape characters so they can be fixed to follow the Standard conforming string syntax instead.

Default Value: 1

Example:

ALTER DATABASE mydb SET EscapeStringWarning = '1';

StandardConformingStrings

Determines whether ordinary string literals ('...') treat backslashes (\) as string literals or escape characters. When set to '1', backslashes are treated as string literals, when set to '0', back slashes are treated as escape characters.

Tip: To treat backslashes as escape characters, use the Extended string syntax:

(E'...');

See String Literals (Character) in the SQL Reference Manual.

Default Value: 1

Example:

ALTER DATABASE mydb SET StandardConformingStrings = '0';