This is an encoding problem; the
To fix:
UPDATE `catalog_product_entity_text` SET `value` = REPLACE(`value`, BINARY 'Â','') WHERE `value` LIKE BINARY '%Â%';
Run this query, this will remove all such binary characters from descripton and short description.
 is a non-breaking space (HTML entity ) in Unicode being displayed in Latin1.To fix:
UPDATE `catalog_product_entity_text` SET `value` = REPLACE(`value`, BINARY 'Â','') WHERE `value` LIKE BINARY '%Â%';
Run this query, this will remove all such binary characters from descripton and short description.
No comments:
Post a Comment