Encoding problems identified and corrected easily

So one customer's webpage showed odd characters in otherwise normal text, like “we’re”. No doubt this looked very much like an encoding error between ISO-8859-x/cp1252 and UTF-8; three characters and all being outside the ASCII plane is a hint to this.

Update 2016-02-05: I turned the fixing process into a program which speaks to me more than a full article: decode_mojibake_1252.c

Posted 2010-03-07 23:03 / Tags: Encoding, Sql. / link