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 ('sejur* ' 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 ('sejur* ' IN BOOLEAN MODE) ) OR a.id IN (962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990) ) ) 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 ('sejur* ' IN BOOLEAN MODE) ) OR a.id IN (962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990) ) )
error