Re: Char to Varchar on Innodb

2004-10-21 Thread Heikki Tuuri
Gary, - Alkuperäinen viesti - Lähettäjä: "Gary Richardson" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Thursday, October 21, 2004 4:49 AM Aihe: Re: Char to Varchar on Innodb > I

Re: Char to Varchar on Innodb

2004-10-20 Thread Gary Richardson
I'm not too worried about it myself, but I can see how less magic on a database server is better. Without actually trying it, if I mix CHAR's and VARCHAR's in a table, does SHOW CREATE TABLE reflect the internal conversion? If you wanted to reduce fragmentation in an Innodb table, wouldn't all th

Re: Char to Varchar on Innodb

2004-10-20 Thread Martijn Tonies
Hello, > those 'silent column specification changes' affect all table types. That > feature has caused lots of user questions over years. It is in the TODO to > remove that feature from MySQL, because it is not standards compliant. In > InnoDB, a reason to use a CHAR column in some cases is to red

Re: Char to Varchar on Innodb

2004-10-20 Thread Heikki Tuuri
Gary, those 'silent column specification changes' affect all table types. That feature has caused lots of user questions over years. It is in the TODO to remove that feature from MySQL, because it is not standards compliant. In InnoDB, a reason to use a CHAR column in some cases is to reduce fr