Skip to main content

VSQL in Unix- Locale Issue

  • July 17, 2014
  • 5 replies
  • 21 views

mohammed_yousuf
Hi,
I am trying to connect to HP Vertica DB from AIX unix box, I am getting error message as follows 
"Invalid locale: run the "locale" command and check for warnings". When I issues the locale command I could see that locale is set to en_US.UTF-8

$ locale
LANG=en_US.UTF-8
LC_COLLATE="C"
LC_CTYPE="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_MESSAGES="C"
LC_ALL=en_US.UTF-8

Can anyone help and advice whats wrong or do I need to do any other settings?


5 replies

Shobhit_Garg
Forum|alt.badge.img
  • Participating Frequently
  • July 17, 2014
Hi,

Kindly modify the locale settings so that all locale paramters should have "en_US.UTF-8" and not "C".

Thanks,
Shobhit

mohammed_yousuf
  • Author
  • New Participant
  • July 17, 2014
Hi Shobit,

LC_ALL is currently set to en_US.UTF-8. LC_ALL overrides all LC_* environment variables with the given value.

Please Advice.

eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • July 21, 2014
Did you able to connect from diffrent server ?

mohammed_yousuf
  • Author
  • New Participant
  • July 21, 2014
I am able to connect from my Windows machine. Did not tried on other AIX server, the idea is to connect first from Development server and then move to Production.

Subbarao
  • New Participant
  • July 31, 2015

I am also facing similar issue.. any pointers on resolution is really helpful.