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

SELECT image.id FROM image INNER JOIN image_display ON image.id = image_display.image_id INNER JOIN subject_code ON image.id = subject_code.image_id WHERE event LIKE 'AFLW 2019 Rd 01 - Brisbane v GWS⊂_code=all' AND image_display.website_id = 'gspimages' AND active = 1 AND subject_code.code IN ('15084000', '15084001') ORDER BY date_created DESC