SET LOCALE

Specifies locale for the current session.

You can also set the current locale with the vsql command \locale.

Syntax

SET LOCALE TO ICU‑locale‑identifier

Parameters

locale‑identifier

Specifies the ICU locale identifier to use, by default set to:

en_US@collation=binary

If set to an empty string, Vertica sets locale to en_US_POSIX.

The following requirements apply:

  • Vertica only supports the COLLATION keyword.
  • Single quotes are mandatory to specify collation.

Privileges

None

Commonly Used Locales

For details on identifier options, see About Locale in the Administrator's Guide. For a complete list of locale identifiers, see the ICU Project.

de_DE German (Germany)
en_GB English (Great Britain)
es_ES Spanish (Spain)
fr_FR French (France)
pt_BR

Portuguese (Brazil)

pt_PT Portuguese (Portugal)
ru_RU Russian (Russia)
ja_JP Japanese (Japan)
zh_CN Chinese (China, simplified Han)
zh_Hant_TW Chinese (Taiwan, traditional Han)

Examples

Set session locale to en_GB:

=> SET LOCALE TO en_GB;
INFO 2567:  Canonical locale: 'en_GB'
Standard collation: 'LEN'
English (United Kingdom)
SET

Use the short form of a locale:

=> SET LOCALE TO LEN;
INFO 2567:  Canonical locale: 'en'
Standard collation: 'LEN'
English
SET

Specify collation:

=> SET LOCALE TO 'tr_tr@collation=standard';
INFO 2567:  Canonical locale: 'tr_TR@collation=standard'
Standard collation: 'LTR'
Turkish (Turkey, collation=standard)  Türkçe (Türkiye, Sıralama=standard)
SET