Large Binary Data and Blob’s | Development, Analysis And Research

Large Binary Data and Blob’s Development, Analysis And Research: "Large Binary Data and Blob’s"


TINYBLOBA BLOB column with a maximum length of 255 (2^8 - 1) bytes. BLOB[(M)]A BLOB column with a maximum length of 65,535 (2^16 - 1) bytes.Beginning with MySQL 4.1, an optional length M can be given. MySQL will create the column as the smallest BLOB type largest enough to hold values M bytes long. MEDIUMBLOBA BLOB column with a maximum length of 16,777,215 (2^24 - 1) bytes. LONGBLOBA BLOB column with a maximum length of 4,294,967,295 or 4GB (2^32 - 1) bytes. Up to MySQL 3.23, the client/server protocol and MyISAM tables had a limit of 16MB per communication packet / table row. From MySQL 4.0, the maximum allowed length of LONGBLOB columns depends on the configured maximum packet size in the client/server protocol and available memory.

www.svdeals.com