Loading UCS – 2 Little Endian to Vertica

Moderator: NorbertKrupa

Post Reply
Vertica_grm
Newbie
Newbie
Posts: 17
Joined: Tue Apr 21, 2015 8:35 pm

Loading UCS – 2 Little Endian to Vertica

Post by Vertica_grm » Wed Apr 22, 2015 9:14 pm

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?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Loading UCS – 2 Little Endian to Vertica

Post by NorbertKrupa » Thu Apr 23, 2015 4:09 am

Have you tried using recode or iconv in Linux and piping it to vsql (copy from stdin)...?
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Data Load”