Error Number: 1267

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

SELECT `users`.*, `cvs`.*, `cvs`.`premium` as premium_cv FROM (`cvs`) JOIN `users` ON `cvs`.`user_id` = `users`.`id` WHERE `cvs`.`offline` = '0' AND `users`.`province` LIKE '%Jaén%' ORDER BY `cvs`.`premium` DESC, `users`.`surname` asc