Re: Null fields - does it take up physical storage space?

In <CoowGE.MB4@exodus.iti.gov.sg> davinboo@iti.gov.sg (Davin Boo Kia Pong) writes: >I would like to know that when I declare fields as Nulls by default, >will the fields still take up the bytes allocated in my physical >storage even when nothing has been entered for these fields. >Also, If i were to declare a 4 byte field and use only 1 byte, >will all the 4 bytes still be taken up for storage in the harddisk? >Is there any difference in this case if it were to be an integer field >as compared to a char field? The field types VARCHAR, TEXT, and BYTE, which are available only through the OnLine engine, are variable-length (contents of the field impacts storage requirements). All other field types are fixed-length. A field defined as CHAR(n) will occupy n bytes on the disk.