As the new MySQL has added the charset and collation features, I'm running into problems with updating a pretty old installation.
Since the upgrade is not working, what we are planning to do is install a 1.1.10 first, the migrate the table data. The problem is that the current installation is using something like iso (since the server has been updated, it may be latin1_swedish_ci, as it is the default).
Because we copied the data into a utf-8 database, as you may have guessed, lots of data is corrupted (since we use lots of special charcters) many user names, last names, even passwords are now unavailable.
The author index, which once worked, now does not list authors correctly, because it cannot recognize accented characters as one byte (instead they are 2-byte..), so our author index has either two sets of E's (with a hack we created to list accented letters as the original non-accented letter), or an author with the surname Évora is listed among the A's... (also, you should list the author index by last name first, since that's the way the letters link the authors...).
I guess what I'm looking for are suggestions to solve this problem... because I'm running out of ideas and time...