An Error Was Encountered

Error Number: 1267

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

select members.* FROM members JOIN article_authors ON article_authors.member_id = members.id WHERE CONCAT(first_name,'-',last_name) = 'Jos��-Teodoro'