When I first set up Very True Things, I set the character encoding to ISO-8859-1 instead of the recommended UTF-8 because I wanted to include the French Revolutionary Calendar dates by simply linking to the existing JavaScript file, which had all the accented characters encoded in ISO-8859-1.
When I added the Scrobbles plugin it fetched my play list from Last.fm, encoded in UTF-8. Obviously I have a lot of bands on my list with röck döts…
So I bit the bullet and converted the JavaScript to UTF-8 and I’ve just done the same with all the pound signs on the dinosaurs page. But there are a load of pound signs scattered throughout lots of other posts and they’re showing up as those very pretty question mark in a diamond symbols that Opera uses (or ugly square boxes, etc. in other browsers).
Any Word Press/PHP/MySQL experts got a quick and easy way to search and replace across the whole posts database? I can think of a couple of ways to do it but don’t really fancy any of them.
thirsty
