Question

What is the size of the BIT type?

(a) 1

(b) 2

(c) 3

(d) variable

This question was posed to me in class test.

I'm obligated to ask this question of Running Multiple Servers topic in section General MySQL Administration of MySQL

Answer 1

The correct choice is (d) variable

The best I can explain: All the numeric datatypes used in MySQL vary over the fields. However, the maximum size is fixed. Unlike the other numeric types, the size of the BIT datatype depends on the length of the field.