mysql - does BIT fill unused space past 1 byte? -


My tables may have a very large line length, if I am reading correctly, then BIGINT Will carry 8 full bytes with the value of 1 .

It seems extremely incomprehensible.

Does a 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.

In other words, if I do not have the 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?

, 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.

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -