MySQL 5.0 Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

Above error in MySQL 5.0

Make change in my.cnf

default-character-set=latin1 to default-character-set=utf8

at two places

Restart your mysql server your error will solved.