Difference between BINARY and VARBINARY in MySQL

Q

What Are the Differences between BINARY and VARBINARY in MySQL?

✍: FYIcenter.com

A

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.

 

⇒Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 197👍, 0💬

General MySQL Oracle SQL Server