Internationalization parameters
The following table describes internationalization parameters for configuring Vertica.
Query the CONFIGURATION_PARAMETERS system table to determine what levels (node, session, user, 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 backslashes are used in a string literal. This can help locate backslashes that are being treated as escape characters so they can be fixed to follow the SQL standard-conforming string syntax instead. Default: 1 |
| StandardConformingStrings |
Determines whether character string literals treat backslashes () as string literals or escape characters. When set to -1, backslashes are treated as string literals; when set to 0, backslashes are treated as escape characters. TipTo treat backslashes as escape characters, use the Extended string syntax
Default: -1 |