I am trying to work out how to remove the character  from a mySQL database. It has been converted for me by someone else who hasn't done a great job.
table is ps_product_lang
fields are description AND description_short
I think my query should be
update ps_product_lang set description = replace(description, ‘Â’, ‘’)
But what should I put in where the  is? When I try to do a search it finds every 'a'.
ASCII code 182 = Â ( Letter A with circumflex accent or A-circumflex )
( HTML entity = Â )
Thanks for any advice.
解决方案
CHAR(182) matches the character that is integer code 182.
So you can do this:
update ps_product_lang set description = replace(description, CHAR(182), '')
Documentation for CHAR() is here