On Jul 1, 11:48 am, Sebastian <[email protected]> wrote: > OK, > > it was working perfectly when I just made sure that my csv file is in > utf-8 encoding format. > > I deleted some of my programm, so I had to write a lot of stuff again. > > If I now upload a csv file which is in utf-8 format and then I have > every time in the first row that the first three character are: \xEF > \xBBxBF
That's a utf BOM: a magic unicode character that tells whoever is reading the stream what endianness is and also allows to tell UTF8 apart from utf16 You can safely strip them from the file. > > I read that these is something about unicode and ordering, but i don't > know where these hex chars come from. > > Also every german special character is also shown in this hex code, > e.g. "k\xC3\xBChler" should be "kühler" That is probably just an output thing if you are seeing this in a terminal window- \xC3\xBC is the utf8 sequence for ü Fred > > If I use files in other encodings there are not these three chars in > the beginning, but every special char is "?" > > Has anyone an idea where this comes from? > > Cheers, > Sebastian > > On 22 Jun., 13:26, Sebastian <[email protected]> wrote: > > > > > file.temp is an object. I have a form where a csv can be uploaded, but > > it is never stored. That's why I use tempfile. That means that I > > probably have no path to use in that method. > > > BUT, the open and foreach method for the CSV class is working with an > > object whenever I don't have a german special character in my csv file > > or when my csv file is already in utf-8 encoding format. > > > On 22 Jun., 12:05, Chirag Singhal <[email protected]> wrote: > > > > What does file.tempfile return? > > > If it is a file object, then we have a problem, we need to pass in file > > > path > > > here. > > > So call path on the file object and pass that as the first argument. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
