Hi Zahid, Make sure your database.yml file knows to talk to the database in UTF-8. Add the following to you database defined in there:
encoding: utf8 That will ensure that the communication is in UTF-8. Now, Fredrick makes a good point. The input file you are reading from should also be in UTF-8 format and be displaying the characters properly. Double check that as well. Thanks, B. On Tue, Feb 22, 2011 at 3:48 AM, Frederick Cheung <[email protected]> wrote: > > > On Feb 22, 9:30 am, Zahid Karnekar <[email protected]> wrote: >> Hi All, >> >> I have a ruby script which picks up data from a text file and then adds >> the corresponding data into my postgresql database. However, it not >> picking up "diacritic" i.e. characters like "Á, é, ó" etc and throwing >> the following error. >> >> RuntimeError: ERROR C22021 Minvalid byte sequence for encoding >> "UTF8": 0xe9204d HThis error can also happen if the byte sequence >> does not match the encoding expected by the server, which is controlled >> by "client_encoding". Fwchar.c L1534 Rreport_invalid_encoding: >> SELECT * FROM "contacts" WHERE (preferred_given_names = E'ZahidT Miguel' >> and surname = E'Baeza Tordesillas' and (email_work = E'[email protected]' >> OR email_work IS NULL)) LIMIT 1undefined local variable or method >> `some_string' for #<DataImporter:0x55f0cbc @file="d:\\CGCtest.txt"> >> >> I've created the database with UTF-8 encoding. In fact I can manually >> add spanish characters directly into the database, however, not through >> the script and I want the script to do this for me. Any help would be >> much appreciated. >> > > What about the input file you are reading? > > Fred >> Thanks, >> Zahid >> >> -- >> 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 [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. > > -- 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.
