1267- Illegal mix of collations error for string comparison

[Qaiser Mehmood]

Hi,
I am using the mysql on the backend for database and when I m using a join in 2 tables and putting a “=” condition for 2 text fields , its giving me SQL error , but this is very different and it is :

1267- Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation ‘=’

Can anyone help me. The query was

select shortDesc from events e , reminders r , users u

where r.eventId = e.eventId and u.userId = 4

and e.creator = u.userName

Ther errro is comming because of 3rd line characters comparioson.

Qaiser Mehmood