VSQL error: unsupported locale character encoding
OSX 10.10. Getting an error when running the vsql process from Python in both 7.X and 6.X client tools:
vsql: unsupported locale character encoding. Use a utf8 locale, not a US-ASCII localeHere's the command I'm running:
/opt/vertica/bin/vsql -h ## -p ## -U ## -w # -d # -At -c "SELECT * FROM MY_SCHEMA.MY_TABLE"This command works perfectly when executed from the Terminal, just fails with that error when ran via Python. It even fails when the command is simply to run the vsql executable with no params:
CMDstr = '/opt/vertica7/bin/vsql' result,error = Popen(CMDstr, shell=True, stdout=PIPE, stderr=PIPE).communicate() print(error) # yields above errAnyone seen this error before?