The BIT data type is used to store bit-field
values. A type of
BIT( enables
storage of M)M-bit values.
M can range from 1 to 64.
To specify bit values,
b' notation
can be used. value'value is a binary value
written using zeros and ones. For example,
b'111' and b'10000000'
represent 7 and 128, respectively. See
Section 9.1.6, “Bit-Field Literals”.
If you assign a value to a
BIT( column that
is less than M)M bits long, the value
is padded on the left with zeros. For example, assigning a value
of b'101' to a BIT(6)
column is, in effect, the same as assigning
b'000101'.