1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='

SELECT t.old, t.types_name FROM products p, products_to_categories p2c, products_details ps, types t WHERE p2c.categories_id = '71' AND p2c.products_id = ps.products_id AND p.products_id = p2c.products_id AND p.products_status = '1' AND ps.details_name = 'type' AND t.types_name != '' AND t.old = ps.value_id AND p.city='S�rup' ORDER BY t.col, t.sorting ASC

[XT SQL Error]