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.
use utf-8 locale not roman8 locale
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: use utf-8 locale not roman8 locale
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:
Also, make sure that all input data for vsql is in UTF-8.
Here's mine:
Code: Select all
[dbadmin@Vertica1 ~]$ echo $LANG
en_US.UTF-8
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.