Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' select v.*, vc.constructeurId from verbe v left join verbe_constructeur vc on vc.verbeId = v.id and vc.constructeurId = 4 where v.verbeBinaire = 'complŠter'