Answers

Question and Answer:

  Home  MySQL Programming

⟩ What Are the Differences between BINARY and VARBINARY?

Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences:

► BINARY stores values in fixed lengths. Values are padded with 0x00.

► VARBINARY stores values in variable lengths. Values are not padded with any bytes. But 1 or 2 extra bytes are added to store the length of the data.

 145 views

More Questions for you: