It means we've got two extra queries per table that we don't need and don't know the supposed purpose of. Can you try just the ALTER TABLE tbl_name CONVERT TO CHARACTER SET queries and see what results you get?
On Tue, Dec 9, 2008 at 4:54 PM, Arthus Erea <[EMAIL PROTECTED]> wrote: > > I'm not sure exactly what that means. > > Can someone familiar with MySQL and character sets take a look and > correct this? > > On Dec 9, 2008, at 4:50 PM, jaypipes wrote: > > > > > Per the MySQL manual: > > > > "If you want to change the table default character set and all > > character columns (CHAR, VARCHAR, TEXT) to a new character set, use a > > statement like this: > > > > ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;" > > > > http://dev.mysql.com/doc/refman/5.0/en/alter-table.html > > > > Therefore, there should be no need to either do the multiple ALTER > > TABLE ... DEFAULT CHARSET or the ALTER TABLE ... BINARY stuff. > > > > Cheers, > > > > Jay > > > > On Dec 8, 9:48 pm, "Chris Meller" <[EMAIL PROTECTED]> wrote: > >> To be more specific, he said on IRC that it seemed to break at > >> apostrophes > >> or '-'s... For whatever that's worth. > >> > >> On Mon, Dec 8, 2008 at 9:37 PM, Arthus Erea <[EMAIL PROTECTED]> > >> wrote: > >> > >>> In short, r2909 broke my site and caused massive data loss. I have > >>> minimal knowledge of SQL but will be willing to run whatever code is > >>> needed to debug. Please see #795. > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
