Sharing some useful tips, solutions and notes for Geeks.

Tuesday, January 21, 2020

 issue in description after migration Magento 2

This is an encoding problem; the Â 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: