A BIT value in a result set is displayed as a binary string.

a-bit-value-in-a-result-set-is-displayed-as-a-binary-string

A BIT value in a result set is displayed as a binary string.

A. True

B. False

This question was posed to me in an interview.

This intriguing question comes from Data Value Categories in section Data Types of MySQL

Correct answer is A. True

For explanation I would say: In MySQL, the BIT values in the result set are displayed as binary strings. In order to convert them to integers, either a zero is added or the ‘CAST()’ operator is used to cast them.