I've been looking at some products, and somehow, somewhere, the ones which involve fractions of an inch (ie: 2¾") have become corrupted. For example:

So, I looked in the database, and it looks even weirder in there!
So, if I do this:
Code:
UPDATE products_description SET products_description =  REPLACE (products_description, 'Ã?ÂÂ', '' );
It says there's zero rows
And if I do this:
Code:
UPDATE products_description SET products_description =  REPLACE (products_description, 'Ã?Â', '' );
it comes back with
Code:
#1270 - Illegal mix of collations (latin1_general_ci,IMPLICIT), (utf8_unicode_ci,COERCIBLE), (utf8_unicode_ci,COERCIBLE) for operation 'replace'
Sigh. Any ideas?