Neetin Kumar
2008-Sep-17 11:15 UTC
Mysql::Error: #HY000Illegal mix of collations (latin1_swedis
while parsing the xml i try to read user name which having some Special charcter,so while parsing i got the error :-> Mysql::Error: #HY000Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''like'': SELECT * FROM `users` WHERE (firstname like ''€uromole'') LIMIT 1 (ActiveRecord::StatementInvalid) i call like [ user User.find(:first,:conditions=>["firstname like ?",node[''id'']]) ] help me to solve this issue........ -- Posted via http://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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org 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 -~----------~----~----~----~------~----~------~--~---