BLOB size

aopen

What is the actual size in bytes for BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB?

Thanks

devinemke

did you bother looking at the manual page on Data Type Storage Requirements?

aopen

Thanks... Question..

What is the difference between int(2) and int? Does int(2) take less space than int?

I read this article: http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html - i don't see the difference with inserts and selects.

NogDog

The number in parentheses after "INT" has nothing to do with what is stored, only how the data may be output in a query. The output is left-padded with spaces to the specified width if the value has fewer digits than the specified width. In the vast majority of PHP/MySQL applications, this effect has no impact on what we do, and as stated earlier it has no impact on the storage space required for a value.

aopen

I have field in the database that will be more than 0 and less than 100. I can use 'tinyint' type.

What are the benefits for using 'TINYINT' type verses 'INT' type in this case?

NogDog

TINYINT only requires 1 byte of storage space, whereas INT require 4 bytes for each entry.