From: Nathaniel Smith <nwjsmith@...>
Date: 2010-12-02T02:01:51+09:00
Subject: Re: FasterCSV parsing issues

I've had similar issues recently, and they are due to character
encodings. Something like Iconv will probably be necessary to convert
the files to a standard encoding

On Wed, Dec 1, 2010 at 11:52 AM, Jeremy Woertink
<jeremywoertink@gmail.com> wrote:
> I'm using FasterCSV to do an import into my DB, and the CSV file
> contains European words. I have French, Italian, and German words which
> contain accents and such. When I try the import it throws a
> FasterCSV::MalformedCSV error, but if I remove just the letters with
> accents on them, it will upload just fine.
>
> Here is a sample row:
>
> Universal,ID,Kir,"Commonly, white wine with Cassis. Traditionally, the
> cocktail kir (also known as vin blanc cassis in French) is made with
> Aligoté. Kir Royal is made with Champagne instead of Aligoté."
>
> Notice the 2 "e" with accents on them. I can remove these and it's fine.
> I'm assuming this is an encoding issue. The CSV file could be created by
> any number of people in any number of different locations using any
> number of programs. Do I need to do something like use Iconv to convert
> to a standard encoding first, then upload?
>
>
> Thanks
>
> ~Jeremy
>
> --
> Posted via http://www.ruby-forum.com/.
>