MySQL 8 Administrator???s Guide

Bit value literals

To store bit values in a table column, we must understand bit literals. As mentioned earlier, bit literals can be written using the b'val' notation. There is another notation, which is the 0bval notation.

One important note about b'val' or 0bval notations is that the letter case of the leading b doesn't matter. We can specify b or B. A leading 0b is case-sensitive, and can't be replaced with 0B.

The following is the list of legal and illegal bit value literals.

Legal bit value literals:

• b'10'
• B'11'
• 0b10

Illegal bit value literals:

• b'3' (1 and 0 are the only binary digits)
• 0B01 (0B is not valid; it should be 0b)

As a default, a bit literal is a binary string. We can confirm this with the query, as shown in the following ...