mysql - does BIT fill unused space past 1 byte? -
My tables may have a very large line length, if I am reading correctly, then It seems extremely incomprehensible. Does a In other words, if I do not have the , it seems that you are out of luck: a bit always the size you specify In fact, you might consider sorting your bits into a Blob field, because they are and variable lengths. BIGINT Will carry 8 full bytes with the value of
1 .
bit work in the same way, or is it a variable length hybrid? I know that using less than 1 full byte will still use 1 byte of disk space, whereas other
BIT s, for example, 8
BIT 1 column Only if I am reading correctly, take 1 byte.
BIT 41 any other
BIT column, then a line will be
0 Also, in that column, the use of 1 byte or full 6 bytes is opposite to 2 ^ 41-1, which will definitely take full 41 bits?
Comments
Post a Comment