An Error Was Encountered

Error Number: 1267

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

select award_title, award_year, award_ttype, award_ptype, award_atype, award_level from awards where award_author = 'Herbert Kaußen' and award_level = 1 order by award_year, award_ptype limit 0, 10