How do I replace non-printable barf from charset mangling with sed/awk or perl? I have a collection of flat html files which at some point in the past got corrupted charset-wise. You can see an example broken file here. Apache serves them up utf-8 in a clearly broken way, but dropping in a .htaccess to force iso-8859-1 doesn't help (see here) and ditto windows-1252 (see here). When I open the files in vim or less, I see "<89>" as if it were one char for what should be ’ (right curly quotation mark). I don't know how to replace that in a programmatic way since it's not a literal bracket-eight-nine-bracket. Halp?
posted by tarheelcoxn on Nov 24, 2008 - 11 answers

I need to display Portuguese characters on a webpage, but when I upload the files to the Apache server, they stop displaying correctly. And, yes, I'm using UTF-8 encoding. [more inside]
posted by John Shaft on Oct 9, 2008 - 11 answers

What does the construct "?/" refer to in Ruby? [more inside]
posted by nakedcodemonkey on Jan 14, 2008 - 6 answers

help me convert a mySQL database to UTF-8. [more inside]
posted by Baud on May 12, 2007 - 3 answers

Why can't firefox display some punctuation characters correctly? [more inside]
posted by Gamblor on Sep 27, 2006 - 11 answers

How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted by cmyers on Aug 28, 2006 - 8 answers