1267- Illegal mix of collations error for string comparison
Posted by: Qaiser Mehmood
Date: July 01, 2005 06:42AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1267- Illegal mix of collations error for string comparison
8410
July 01, 2005 06:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.