use utf-8 locale not roman8 locale

[bhupal]

Hi all

when i am executing sql query in unix with vsql command, i am getting error like

error is: use utf-8 locale not roman8 locale.

why i am getting this error, what would be the solution to overcome this.

!# /bin/ksh

exec_vsql=/app/informatica/infa_drivers/vertica/opt/vertica/bin/vsql

$exec_vsql -h servername -p portname -U username -w password -c"select *from schemaname.tablename;" > text.txt

echo"done"
exit

when i execute this script i am facing the above error.

i am using putty to connect unix. and also in unix i have set translation as utf-8.

to execute this script what are all the things need to be change in sql and or unix.

basically when we will get this type of error?

please anybody can help me regarding this issue.

thanks in advance.

[JimKnicely]

What is your Linux LANG environment variable set to on the server? I believe that it must indicate the use of UTF-8 Unicode encoding.

Here's mine:

Code: Select all

[dbadmin@Vertica1 ~]$ echo $LANG
en_US.UTF-8

Also, make sure that all input data for vsql is in UTF-8.