MySQL error in file: /engine/modules/catalog/goods.php at line 254

Error Number: 1267

The Error returned was:
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'regexp'

SQL query:

SELECT `good_id`, g.type FROM `catalog_params_values` pv LEFT JOIN `catalog_goods` g ON (g.id = pv.good_id) WHERE `param_id` = '17' AND `good_id` IN (0,1,5,2,23,24,28,30,32,35,39,41,46,47,50,54,61,62,65,67,68,74,75,76,77,119,127,129,130,133,142,156,163,164,166,167,171,175,180,182,183,185,189,207,208,217,220,229,263,264,265,267,269,270,271,274,276,278,282,287,303,304,305,308,309,311,386,323,324,325,327,341,344,346,350,351,360,361,362,370,371,372,373,395,396,397,398,400,401,405,409,413,457,485,490,491,498,520,538,566,579,587,597,598,613,615,624,625,626,644,645) AND `value_on` = '1' AND `value` regexp '1 �������'