I thought I would throw in a link to a howto I wrote over at OG Consulting. I would wager there are a few people out there that have legacy data in an old MySQL installation (4.0.x and below), and need to bring their installation up to date. I believe the MySQL folks are going to EOL (end of life) MySQL versions less than 4.1.x, so it is now a necessity to get it up to speed. For those of you with a lot of legacy data, I've written a little tutorial on stuffing your mixed character encoded data into a fresh shiny new MySQL installation.
Blog