MySQL Forums
Forum List  »  Quality Assurance

please help mysql error
Posted by: prashanth menon
Date: September 27, 2007 12:04AM

HI everyone,
when i try executing a particular query which involves comparision its giving me error.

SQL query:

SELECT *
FROM `transaction`
WHERE `status` = 'pending'
LIMIT 0 , 30

MySQL said: Documentation
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

I m using MySQL - 4.1.5-gamma
The query when executed on other server which has MySQL - 4.1.22-standard doesn't give this error!

Options: ReplyQuote


Subject
Views
Written By
Posted
please help mysql error
3060
September 27, 2007 12:04AM


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.