Hello, I am having this mysql error in my ruby on rails application. 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 1mysql 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 is welcomed --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
I am using mysql version 5.0.22 On Jan 21, 2:57 pm, sam <ladak....-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hello, > > I am having this mysql error in my ruby on rails application. > > 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 > > 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 is welcomed--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Maybe Matching Threads
- Update to website not printing special Characters
- UFT8 String looks great in MySql, garbage in browser
- MySQL connection collation
- ferret for professionals
- Mysql::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)