Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c
command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv
- gives charset=binary
Tried converting it into utf-t using
iconv -f binary -t utf-8 input.csv -o output.csv
But it gives error- conversion from binary to utf-8 unsupported.
Is there any way to create the file in utf-8 format by default.
Thanks in advance!