Ruby on Rails

> So, what are the best steps to take a .CSV file that is full of
> ISO-8859-1 characters, and upload it to the DB so they are displayed
> exactly how they are in the file?
>
Personally I'd store everything in utf-8 and convert to/from that when
a file is uploaded or downloaded

> Bonus Question:
>
> In case anyone knows.... The CSV file is being created with Microsoft
> Excel. Is there a way to save the file as UTF-8 so I can just move on
> with my life? :)

Excel sucks at this. I've always ended up using utf-8 (and do check
that what you have is iso Latin 1 rather than something else - excel
can be very odd in this area)

Fred
>
> Thanks for the help,
>
> ~Jeremy
>
> --
> Posted viahttp://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.