# Mysql collations error

**URL:** <https://www.ruby-forum.com/t/mysql-collations-error/126758>\
**Category:** Rails\
**Created:** [January 21, 2008, 11:58pm UTC](https://www.ruby-forum.com/t/mysql-collations-error/126758 "2008-01-21T23:58:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/5f9b8f/32.png) [@sam](https://www.ruby-forum.com/u/sam)\
**Post date:** [January 21, 2008, 11:58pm UTC](https://www.ruby-forum.com/t/mysql-collations-error/126758/1 "2008-01-21T23:58:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/5f9b8f/32.png) [@sam](https://www.ruby-forum.com/u/sam)\
**Post date:** [January 22, 2008, 12:31am UTC](https://www.ruby-forum.com/t/mysql-collations-error/126758/2 "2008-01-22T00:31:12Z")

</div>

I am using mysql version 5.0.22