MySQL Forums
Forum List  »  MySQL Query Browser

query mixing-unexpected error
Posted by: shiva reddy
Date: October 27, 2010 03:40AM

hi guys....

when i execute the bellow query i am getting this error"Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '='"

select income,bucket from
(select income,
(case when income between 0.00 and 2000.00 then 'Bucket1'
when income between 2001.00 and 3000.00 then 'Bucket2'
when income between 3001.00 and 4000.00 then 'Bucket3'
when income between 4001.00 and 6000.00 then 'Bucket4'
when income between 6001.00 and 10000.00 then 'Bucket5'
else 'Bucket6' end) as bucket
from bi02_customer)a
where bucket=(select salbucket from m_caprosel) group by bucket;

jest i replaced (select salbucket from m_caprosel) with 'Bucket4', i am getting expected result,the m_caprosel table field(salbucket) also having only onerecord "Bucket4"

i didn't understood wht's my mistake,

pls let me know any one...

Thanking u in advance..

Options: ReplyQuote


Subject
Written By
Posted
query mixing-unexpected error
October 27, 2010 03:40AM


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.