Joshua Beall wrote:
Hi All,
I am a bit confused by the MySQL documentation on this subject. From http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
"The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and TEXT column accounts for only five to nine bytes toward this size."
So, the maximum size is 64k, but you can go over that limit by using BLOB or TEXT types, because although they can hold up to 4gb (2^32 bytes for LONGBLOB/LONGTEXT types), they still only contribue 5 to 9 bytes? What? Am I reading that correctly?
Thanks for any clarification,
-Josh
5-9 bytes only go toward the total row size because TEXT and BLOB types don't get stored in the row itself, just a pointer to them. That pointer takes up 5-9 bytes. At least, that's how I understand it.
Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
