Unanswered: nulls and (empty strings) takes up disk space ?
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 dont? Or all behave like CHAR(M) ?