jos-Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' SQL=SELECT a.name, COUNT(a.item_id) AS items FROM #__zoo_tag AS a, #__zoo_item AS b USE INDEX (ID_APPLICATION_INDEX) WHERE 1 AND a.item_id = b.id AND b.application_id = 1 AND LOWER(a.name) LIKE '%cartograf´┐Ż´┐Ża%' GROUP BY a.name