What's the difference between MySQL bit vs binary?

Question

We can store binary values using either binary or bit (up to 64 bits).

What is the difference between using binary(n) vs using bit(m) (where n = 8 × m)?

Are they recognized as the same thing by MySQL?

score 2 · Answer 1 · answered Jul 06 '12 at 07:16

2

You can store bits using BIT or BINARY - as you want. The BIT data type may be more usable in logic operations.

There is a small difference in storage:

BINARY(M) requies exact number of bytes - M
the length of the BIT type may vary, find more information here - Data Type Storage Requirements.

answered Jul 06 '12 at 07:16

Devart

1

But what is the difference when we are using a multiple of 8 bits? Like `binary(2)` vs `bit(16)`? – Pacerier Dec 09 '14 at 12:35

1 Answers1