From: Jeremy Woertink <jeremywoertink@...>
Date: 2010-12-02T01:52:03+09:00
Subject: FasterCSV parsing issues

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/.