1267- Illegal mix of collations , problem in string comparison
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.
Subject
Written By
Posted
1267- Illegal mix of collations , problem in string comparison
July 01, 2005 07:12AM
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.