An Error Was Encountered

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

select g.location_words,g.location_words_fr,g.sa_words_fr,g.sa_words,c.name as cityname,p.abbreviation as abbrev, p.name_en as pname, g.city as city_id, p.id as pcode, g.hood from geography g left outer join cities c on c.id=g.city, provinces p where g.name="Sainte HAİnAİdine" and p.id=g.province ;