1270: Illegal mix of collations (utf8_unicode_ci,IMPLICIT), (utf8_unicode_ci,IMPLICIT), (latin1_swedish_ci,IMPLICIT) for operation 'match'<br />SELECT a.*, MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('babies* ' IN BOOLEAN MODE) as `relevance` FROM `pro_items` a
WHERE a.`enabled`=1 AND a.`visible`=1 AND ( ((1 AND MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('babies* ' IN BOOLEAN MODE) ) OR a.id IN (1999) ) ) GROUP BY a.id ORDER BY `relevance` DESC, a.name limit 0,15
1270: Illegal mix of collations (utf8_unicode_ci,IMPLICIT), (utf8_unicode_ci,IMPLICIT), (latin1_swedish_ci,IMPLICIT) for operation 'match'<br />SELECT COUNT(DISTINCT(a.`id`)) as `total` FROM `pro_items` a
WHERE
a.`enabled`=1 AND a.`visible`=1 AND ( ((1 AND MATCH (a.`name`,a.`keywords`,a.`item_description`) AGAINST ('babies* ' IN BOOLEAN MODE) ) OR a.id IN (1999) ) )
error