Csv upload and utf-8?

Rails
1 
Hi,

I need to import data from a .csv file. I use
IO.readlines(file). Everything works fine i.e.,
the data is indeed imported into my table but
there seems to be a problem with special characters
such as the german umlauts (ö, ä, ü). After the first
occurence of such a character the rest of the value
of a column isn't stored. For example, suppose I have
a value "exämple" then what gets stored is "ex" !!

The csv file read in is alright. I think its got something
to do with setting character encoding (once more) as utf-8?

Thanks,
Ram.
2

Ram wrote:

Hi,

I need to import data from a .csv file. I use
IO.readlines(file). Everything works fine i.e.,
the data is indeed imported into my table but
there seems to be a problem with special characters
such as the german umlauts (ö, ä, ü). After the first
occurence of such a character the rest of the value
of a column isn't stored. For example, suppose I have
a value "exämple" then what gets stored is "ex" !!

The csv file read in is alright. I think its got something
to do with setting character encoding (once more) as utf-8?

Thanks,
Ram.

Hi Ram,
have you tried to use fastercvs? I have a similar problem with a cvs
with umlauts and it reports several errors for whatever reason. Maybe
you get yours to work…
Torsten