阅读背景:

如何查看存储在MySQL列中的原始字节?

来源:互联网 

I have a MySQL table properly set to the UTF-8 character set. I suspect some data inserted into one of my columns has been double encoded. I am expecting to see a non-breaking space character (UTF-8 0xC2A0), but what I get when selecting this column out of this table is four octets (0xC3A2 0xC2A0). That's what I would expect to see if at some point somebody had treated an UTF-8 0xC2A0 as ISO-8859-1 then attempted to encode again to UTF-8 before inserting into MySQL. I have a MySQL table properly set to the UTF-8




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: