Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    9

    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 don’t? Or all behave like CHAR(M) ?

    Thanks.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297

  3. #3
    Join Date
    Nov 2005
    Posts
    9
    jfulton,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •