From: John Mcleod Date: 2009-11-18T01:30:43+09:00 Subject: Re: Special characters in csv header using fastercsv Hello Marnen, Thank you for replying. I would consider the non-use of special characters in a database column title, a matter of good form. The only special character I use in database column titles is an underscore and sometimes not that. John Marnen Laibow-Koser wrote: > John Mcleod wrote: >> Hello all, >> I'm kind of new to fastercsv and only have 2 months with Ruby on Rails. >> So this my sound a little newbie. >> >> First, I read a csv file (approx. 6,000 lines). This file comes from a >> different department, so I have no control over the headers. >> >> Second, while reading or parsing the file, the rows are inputted into a >> database. >> >> My problem is my database columns can not have special characters, > [...] > > Why can't they? And are you creating a DB column for each column in the > CSV file? > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > marnen@marnen.org -- Posted via http://www.ruby-forum.com/.