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.
