Wow, sounds weird. I wonder if the MySQL folks have a bug open about this? On Tue, 2007-05-15 at 13:17 +0200, [EMAIL PROTECTED] wrote: > I got it. > > It's a mysql bug (at least so it seems to me): changing the COLLATION > of a table with foreign keys looses the ON UPDATE and ON DELETE. > > I'm fixing my database now, I'll make a couple more investigation > later and report it to mysql ab. > > This is also what broke the database in the first instance. > > The DB used to be latin1 then it was switched to utf8, that was when > it loose the on update and on delete boundings. > > This is also what happened today as the database first was set up in > latin1 and then I later changed it to utf8. > > Terrible. > > > Naviga e telefona senza limiti con Tiscali > Scopri le promozioni Tiscali adsl: navighi e telefoni senza canone Telecom > > http://abbonati.tiscali.it/adsl/ > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
