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 -~----------~----~----~----~------~----~------~--~---
