Failed to execute the SQL query

select id from  ipo__item  i where i.title like 'Un(e)%Chargé%des%Actions%d’Insertion%vers%l’Emploi%(H%F)%(Catégorie%:%A)%-%Conseil%général%du%Loiret%-%France' and i.cid=156 and month(ifnull(i.pubdate,i.added))= 5  and year(ifnull(i.pubdate, i.added))= 2017  and dayofmonth(ifnull(i.pubdate,i.added))= 19  and not(i.unread & 4)  and not(i.unread & 8)  order by i.added desc, i.id asc

Error 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'