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?
Loading UCS – 2 Little Endian to Vertica
Moderator: NorbertKrupa
-
- Newbie
- Posts: 17
- Joined: Tue Apr 21, 2015 8:35 pm
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Loading UCS – 2 Little Endian to Vertica
Have you tried using recode or iconv in Linux and piping it to vsql (copy from stdin)...?
Checkout vertica.tips for more Vertica resources.