use utf-8 locale not roman8 locale
Posted: Tue Jun 11, 2013 6:36 pm
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.
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.