MySQL error in file: /engine/modules/catalog/vendors.php at line 106

Error Number: 1267

The Error returned was:
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'

SQL query:

SELECT v.id, v.name, v.sef_name, v.phone, v.adresse, v.comment, v.image, v.site, v.work_days, v.work_time, AVG(r.rating) as rating FROM `catalog_vendors` v left join `catalog_vendor_ratings` r on (r.vendor_id = v.id AND r.status = '1') WHERE v.status = '1' AND v.name LIKE '�%' AND (v.city_id IN (0,1,2)) GROUP BY v.id ORDER by `rating` DESC LIMIT 0, 100