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.

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.