Hello, I am having following mysql error. ActiveRecord::StatementInvalid occurred in> event#lg: > Mysql::Error: Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > operation ''='': select * from locations where country = ''HU'' and > geo_state = ''08'' and city = ''Pázmánd'' and zip = ''(null)'' and lat > ''47.283'' and lng = ''18.666'' and metrocode = ''0'' and areacode = ''0'' > and isp = ''UPC Magyarorszag Kft.'' and organization = ''UPC > Magyarorszag Kft.'' limit 1I am using mysql server version 5.0.22. mysql collation variables are set to: collation_connection latin1_swedish_ci collation_database utf8_general_ci collation_server utf8_general_ci mysql character set are set to: character_set_client latin1 character_set_connection latin1 character_set_database utf8 character_set_filesystem binary character_set_results latin1 character_set_server utf8 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ Any suggestion of comments will be greatly appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hi, I''ve run into this same problem. Did you figure it out? Thanks, Ger. On 22 jan, 02:53, sam <ladak....-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hello, > > I am having following mysql error. > > ActiveRecord::StatementInvalid occurred in > > > event#lg: > > Mysql::Error: Illegal mix of collations > > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > > operation ''='': select * from locations where country = ''HU'' and > > geo_state = ''08'' and city = ''Pázmánd'' and zip = ''(null)'' and lat > > ''47.283'' and lng = ''18.666'' and metrocode = ''0'' and areacode = ''0'' > > and isp = ''UPC Magyarorszag Kft.'' and organization = ''UPC > > Magyarorszag Kft.'' limit 1 > > I am using mysql server version 5.0.22. > > mysql collation variables are set to: > > collation_connection > latin1_swedish_ci > > collation_database > utf8_general_ci > > collation_server > utf8_general_ci > > mysql character set are set to: > > character_set_client > latin1 > > character_set_connection > latin1 > > character_set_database > utf8 > > character_set_filesystem > binary > > character_set_results > latin1 > > character_set_server > utf8 > > character_set_system > utf8 > > character_sets_dir > /usr/share/mysql/charsets/ > > Any suggestion of comments will be greatly appreciated.--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hi again, There were some international characters in the data that I was processing. Fortunately, I could just delete that specific data and get on with it. Greetings, Ger. On Jan 27, 7:42 pm, Vorik <goo...-UBhhqR2FKJH0uJH5nF2ROA@public.gmane.org> wrote:> Hi, > > I''ve run into this same problem. Did you figure it out? > > Thanks, > Ger. > > On 22 jan, 02:53, sam <ladak....-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hello, > > > I am having following mysql error. > > > ActiveRecord::StatementInvalid occurred in > > > > event#lg: > > > Mysql::Error: Illegal mix of collations > > > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > > > operation ''='': select * from locations where country = ''HU'' and > > > geo_state = ''08'' and city = ''Pázmánd'' and zip = ''(null)'' and lat > > > ''47.283'' and lng = ''18.666'' and metrocode = ''0'' and areacode = ''0'' > > > and isp = ''UPC Magyarorszag Kft.'' and organization = ''UPC > > > Magyarorszag Kft.'' limit 1 > > > I am using mysql server version 5.0.22. > > > mysql collation variables are set to: > > > collation_connection > > latin1_swedish_ci > > > collation_database > > utf8_general_ci > > > collation_server > > utf8_general_ci > > > mysql character set are set to: > > > character_set_client > > latin1 > > > character_set_connection > > latin1 > > > character_set_database > > utf8 > > > character_set_filesystem > > binary > > > character_set_results > > latin1 > > > character_set_server > > utf8 > > > character_set_system > > utf8 > > > character_sets_dir > > /usr/share/mysql/charsets/ > > > Any suggestion of comments will be greatly appreciated.--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---