After some testing with Meller's help on IRC, it appears the problem is when we convert to binary before going to utf8.
Is there any reason for this? What is the justification for converting to bin first? On Dec 9, 2008, at 5:03 PM, Chris Meller wrote: > 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 -~----------~----~----~----~------~----~------~--~---
