I am not a guru, but I figured I'd try to answer anyway. It needs an extra bit because it has NULLs. I think it uses the bit to mark if the field is NULL or not, but I've been known to be wrong.
http://www.mysql.com/doc/en/Data_size.html --------- Dear gurus, here's my final stupid question for today. Why is the average row length 11 when it should be 10? mysql> DESCRIBE myrowisam; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | col | char(10) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ mysql> SHOW TABLE STATUS LIKE 'myrow%'; +-------------+--------+------------+------+----------------+ | Name | Type | Row_format | Rows | Avg_row_length | +-------------+--------+------------+------+----------------+ | myrowisam | MyISAM | Fixed | 68 | 11 | <--- TIA, --------------------------------------------------------------------- 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
