Page 1 of 1

Loading UCS – 2 Little Endian to Vertica

Posted: Wed Apr 22, 2015 9:14 pm
by Vertica_grm
I'm trying to load a csv file (which I saw in notepad++ to be in UCS – 2 Little Endian) into Vertica. When i load – 2 Little Endian encoded file I'm getting junk values loaded. However, when I change them into UTF-8 I'm able to load the values properly.

However, I need to find a solution which can load the UCS – 2 Little Endian encoded file into Vertica. Any help/suggestions?

Re: Loading UCS – 2 Little Endian to Vertica

Posted: Thu Apr 23, 2015 4:09 am
by NorbertKrupa
Have you tried using recode or iconv in Linux and piping it to vsql (copy from stdin)...?