Re: Fixed table format with VARCHAR

2003-01-25 Thread Sergei Golubchik
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=

Fixed table format with VARCHAR

2003-01-24 Thread Stefan Hinz
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%'; +--