Hi! On Jan 24, Stefan Hinz wrote: > Dear gurus, > > does someone have background information on the following problem ("How > does MySQL do this?"): > > CREATE TABLE myisamFixed (col VARCHAR(10)) TYPE=MyISAM ROW_FORMAT=FIXED; > CREATE TABLE myisamDynamic (col CHAR(10)) TYPE=MyISAM > ROW_FORMAT=DYNAMIC; > > SHOW TABLE STATUS LIKE 'myisam%'; > +----------------------+--------+------------+ > | Name | Type | Row_format | > +----------------------+--------+------------+ > | myisamDynamic | MyISAM | Dynamic | > | myisamFixed | MyISAM | Fixed | > +----------------------+--------+------------+ > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > Gesch?ftsf?hrer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
Did you try 'SHOW CREATE TABLE' for these tables ? :) You'd found that myisamFixed.col is, in fact CHAR(10), and in myisamDynamic.col is VARCHAR(10). The answer to the question ("How does ...") is "By silent column type conversion". Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php