Set the Database Locale (Language)

1. Make sure that the Linux environment variable LANG is set to en_US.UTF-8 on each host. For example, edit /root/.bashrc and add:

   export LANG=en_US.UTF-8

   HOW DOES THIS GET INTO THE VERTICA RUN-TIME ENVIRONMENT?

2. Make sure that no other environment variable supersedes LANG. Vertica determines the database locale by consulting the Linux environment variables in the following order until one is found to be set:
   1. LC_ALL

      determines the values for all locale categories. The value of the LC_ALL environment variable takes precedence over any of the other environment variables starting with LC_ (LC_COLLATE, LC_CTYPE, LC_MESSAGES, LC_MONETARY, LC_NUMERIC, LC_TIME) and the LANG environment variable.

   2. LC_CTYPE

      determines the interpretation of sequences of bytes of text data as characters (for example, single- as opposed to multi-byte characters), the classification of characters (for example, alpha, digit, graph) and the behaviour of character classes. Additional semantics of this variable, if any, are implementation-dependent.

   3. LANG

      determines the locale category for native language, local customs and coded character set in the absence of the LC_ALL and other LC_* (LC_COLLATE, LC_CTYPE, LC_MESSAGES, LC_MONETARY, LC_NUMERIC, LC_TIME) environment variables. This can be used by applications to determine the language to use for error messages and instructions, collating sequences, date formats, and so forth.