Error description: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'

SELECT p.marca_id, m.nombre FROM productos p, productos_detalles pd, marcas m, lineas_productos lp WHERE p.id = pd.producto_id AND m.id = p.marca_id AND p.publicado = 1 AND lp.producto_id = p.id AND (p.nombre like '% 源码搭建, 【访问 Amsiga.com】oJM3t5i, CVV通道, CVV盗刷教程, unicc料站 uHz7%' OR pd.nombre like '% 源码搭建, 【访问 Amsiga.com】oJM3t5i, CVV通道, CVV盗刷教程, unicc料站 uHz7%' OR pd.sku like '% 源码搭建, 【访问 Amsiga.com】oJM3t5i, CVV通道, CVV盗刷教程, unicc料站 uHz7%' OR m.nombre like '% 源码搭建, 【访问 Amsiga.com】oJM3t5i, CVV通道, CVV盗刷教程, unicc料站 uHz7%') group by p.marca_id ORDER BY m.nombre ASC