How to alter the LOCALE on the Vertica server OS. Place this lines into the file /home/dbadmin/.bashrc #Will alter the locale fon the Vertica export LANG=pt_BR.UTF-8 export LC_CTYPE="pt_BR.UTF-8" export LC_NUMERIC="pt_BR.UTF-8" export LC_TIME="pt_BR.UTF-8" export LC_COLLATE="pt_BR.UTF-8" export LC_MONETARY="pt_BR.UTF-8" export LC_MESSAGES="pt_BR.UTF-8" export LC_PAPER="pt_BR.UTF-8" export LC_NAME="pt_BR.UTF-8" export LC_ADDRESS="pt_BR.UTF-8" export LC_TELEPHONE="pt_BR.UTF-8" export LC_MEASUREMENT="pt_BR.UTF-8" export LC_IDENTIFICATION="pt_BR.UTF-8"
#Will alter the locale fon the Vertica export LANG=pt_BR.UTF-8 export LC_CTYPE="pt_BR.UTF-8" export LC_NUMERIC="pt_BR.UTF-8" export LC_TIME="pt_BR.UTF-8" export LC_COLLATE="pt_BR.UTF-8" export LC_MONETARY="pt_BR.UTF-8" export LC_MESSAGES="pt_BR.UTF-8" export LC_PAPER="pt_BR.UTF-8" export LC_NAME="pt_BR.UTF-8" export LC_ADDRESS="pt_BR.UTF-8" export LC_TELEPHONE="pt_BR.UTF-8" export LC_MEASUREMENT="pt_BR.UTF-8" export LC_IDENTIFICATION="pt_BR.UTF-8"