Configuring Locale

March 26, 2020 Contributors

Ensure that your locale is a UTF-8 setting by invoking the locale command. There are two environment variables that identify non-default locale settings: LANG and LC_ALL. We recommend that you set LANG to en_US.UTF-8.

If either variable is set for an ISO value; e.g., LANG=en_US.ISO88591, you must overwrite the setting with a UTF-8 equivalent for the vertica_dba user.

Note

If the system configuration can be changed; then change the setting in the /etc/sysconfig/i18n file. Otherwise, add the override specific to the vertica_dba user in the /var/db/vertica/.i18n file. For example, your locale setting should look similar to this: LANG=fr_FR.

If set, LC_ALL supersedes LANG. If neither is set, Vertica will use en_US.

For examples of how to set LANG, see Implement Locales for International Data Sets.