I have a weird unicode char in my mysql database
the value looks like this
card issuer bank didn<U+0092>t approve your payment
so what should be an apostrophe is a weird unicode char, presumably from windows
I want to replace it, but don't know how to quote it in SQL
tried the following, doesnt work:
replace(text,cast(0x0092 as character set utf8),'x')
0x0092
0x000x92
'\U+0092'
U'0x0092'
and tons of other combinations, none of them work
any ideas?