MySQL查看指定字符的ascll,MySQL中奇怪的Ascii字符。需要查询将其删除

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