Internationalization Parameters
The following table describes the internationalization parameters for configuring Vertica.
Query system table CONFIGURATION_PARAMETERS
to determine what levels (node, session, database) are valid for a given parameter.
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: 0 |
DefaultSessionLocale |
Sets the default session startup locale for the database. This parameter does not take effect until the database is restarted. Default: |
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: 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:
See String Literals (Character) in the SQL Reference Manual. Default: 1 |