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
-~----------~----~----~----~------~----~------~--~---