[rt-users] DB upgrade from 3.4.4 to 3.8.0.

Curtis Bruneau curtisb at vianet.ca
Thu Jul 24 15:50:28 EDT 2008


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



More information about the rt-users mailing list