Failed to execute the SQL query

select id from  ipo__channels  where title like 'B����timent_et_Travaux_publics' and not(mode & 4) 

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