Updating Value in MySQL to replace dodgy UTF8 Characters

  • by

Nice and quick and simple, just replace the dodgy code with the right one.

Also works with text strings:

UPDATE catalog_product_entity_varchar
 SET value = REPLACE(value,'ÂÂ','')


Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

This site uses Akismet to reduce spam. Learn how your comment data is processed.