MySQL Programming Question:
Download Questions PDF

What Are the Differences between BINARY and VARBINARY?

Answer:

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.


Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the Differences between CHAR and VARCHAR?What Are Numeric Data Types?