I understand that nulls and “” (empty strings) will take up disk space for MySQL CHAR(M) data types. If you have CHAR(10), it will take up 10 bytes of space even though the data is null or “”.

What about the other fields like INTEGER, TINYINT, VARCHAR, BLOB etc etc ?
Can anyone point me to …something like a table… where it shows which data types take up space and which don’t? Or all behave like CHAR(M) ?

Thanks.

http://dev.mysql.com/doc/refman/5.0/...uirements.html

also:
http://dev.mysql.com/doc/refman/5.0/en/char.html
http://dev.mysql.com/doc/refman/5.0/en/blob.html

jfulton,

Thanks for the reply..but...
I don't think those URLs has the answer to my question.