1267 - Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

SELECT manufacturers_id, manufacturers_image FROM prd_std_0_manufacturers WHERE manufacturers_name like'HÖFT & WESSEL'

[XT SQL Error]