> ## Content Index
> Fetch the complete content index at: https://werd.io/llms.txt
> Use this file to discover other available public pages before exploring further.

# Bugs, bugs, everywhere
- URL: https://werd.io/bugs-bugs-everywhere/
- Published: 2006-06-27T10:17:14.000Z
- Updated: 2025-06-12T11:01:19.000Z
- Author: Ben Werdmuller
- Tags: General, #ben-684a32da145d7d001be71dae, #Migrated-1749693130536, #wp, #wp-post, #Import 2025-06-11 21:52

Sometimes it's easy to get despondent about bugs showing up in software you write. It's possible to spend so long on a project that it almost feels like one of your children; any perceived imperfection hits you at your core. We've been doing some bugfixing lately, and it can occasionally feel a bit like you're playing whack-a-mole.

But then you use other software.

I've been playing with a major open source PHP survey tool with the brief of making it work in Japanese and Chinese (on a Win2003 IIS box). Now, allegedly it can support these character sets, but in fact it has a little difficulty - so I spent a couple of hours adding the right headers and tweaking things to make it end-to-end UTF-8 compliant. It'll now take pretty much any character set you throw at it; great.

Until you try and export the data to CSV, so you can import it into Excel. It turns out that Excel has a little buglet when you import CSV files - it ignores the character set and basically assumes everything's in ASCII. In particular, Japanese looks a bit like a kitten has had a little dance across the keyboard; it's total gibberish. It turns out you have to rename the CSV file so it has a .txt extension, in order to trigger Excel's "tell me all about this file because I don't understand" wizard, which asks you how it's encoded and makes everything okay again.

After this little adventure, I feel much better about everything. Bugfixing is continuing apace (and will speed up as of next week), but on reflection I think we compare rather well.

This has been an unashamedly techie post, and I apologise - my next one will be about mountain vistas, blue sky thinking and synergy. Or something.