Mysql collation Error

rubyonrails-talk
1

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.

2

Hi,

I've run into this same problem. Did you figure it out?

Thanks, Ger.

3

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.