I'm having an issue with the mysql 4.0 -> 4.1 conversion, the script performs ok (i had to update my DBD::mysql) it generates the proper SQL, I went a step further and merged each tables ALTER into two commands (before-after) so our bigger tables didn't have to dump more then it needs to (very time consuming)..
I have run into an issue with our Users table, we have several emails with french accents (é) that seem to convert properly but the UNIQUE contraint complains that é and e are the same, I had tried removing the constraint and it converts but won't let me add the index again, i had to change my client charset to view the chars properly in mysql client once converted to utf8 from latin1. Does anyone know how I can solve this? Does the server need a setting to differentiate the two in UTF8? Thanks Curtis _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com