Mysql collation Error

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.

Hi,

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

Thanks,
Ger.

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.