What Are the Differences between BINARY and VARBINARY

What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

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.

2007-05-11, 5374👍, 0💬

Popular Posts:

What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...

What is continuous and staged representation? CMMI contains 25 key process areas which organization ...

What Happens to Indexes If You Drop a Table? - Oracle DBA FAQ - Managing Oracle Table Indexes If you...

What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...

Which is the best place to store ConnectionString in Dot Net Projects? I am about to deploy my first...