Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' SQL=SELECT a.*,a.autotype, a.case_active,c.company, c.legal_form, c.created_by as company_id,(SELECT AVG(e.avg) FROM #__data_rating AS e WHERE e.company_rated = a.created_by) AS avg,(SELECT COUNT(d.id) FROM #__data_member_applications AS d WHERE d.jobid = a.id) AS apps,(SELECT k.casenote FROM #__data_case_study AS k WHERE k.id = a.related_case) AS casenote FROM #__data_job_ad AS a LEFT JOIN #__data_company_profile c ON c.created_by = a.created_by WHERE a.status = 1 AND a.expiration > NOW() AND (LOWER(c.company) LIKE '%Thalia B��cher GmbH%') OR (LOWER(a.addinfo) LIKE '%Thalia B��cher GmbH%') ORDER BY a.autotype ASC,a.featured DESC,a.created desc LIMIT 30 Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' SQL=SELECT COUNT(*) FROM #__data_job_ad AS a LEFT JOIN #__data_company_profile c ON c.created_by = a.created_by WHERE a.status = 1 AND a.expiration > NOW() AND (LOWER(c.company) LIKE '%Thalia B��cher GmbH%') OR (LOWER(a.addinfo) LIKE '%Thalia B��cher GmbH%')