SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin2_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

---

SELECT SQL_CALC_FOUND_ROWS product.id,product.name, product.visible, product.evidencenumber, product.shortdescription description, (shopprice * (100+taxrate)/100) shopprice, (marketprice * (100+taxrate)/100) marketprice, ((marketprice-shopprice) *(100+taxrate)/100) save, IF(productaccessory.productid IS NULL,0,1) hasaccessory FROM product LEFT JOIN productaccessory ON productaccessory.productid = product.id WHERE visible=1 AND (name LIKE "%•Statyw mikrofonowy: MIC-6ET ATHLETIC%" OR evidencenumber = "•Statyw mikrofonowy: MIC-6ET ATHLETIC") GROUP BY product.id HAVING shopprice BETWEEN 0 AND 1000000 ORDER BY name LIMIT 0,25