I have tables and columns with latin1 settings and changed all to utf8 and
utf8_general_ci and i didn't losed that info.
This was done with a mysql version 5.0.2x
----- Original Message -----
From: "Aaron Stone" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "DBMail mailinglist" <[email protected]>
Sent: Tuesday, May 15, 2007 10:01 PM
Subject: Re: [Dbmail] I got it
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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
