MySQL SQL - What Are the Differences between BINARY and VARBINARY

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, 4423👍, 0💬

Popular Posts:

What CLASSPATH Settings Are Needed to Run JUnit? It doesn't matter if you run your JUnit tests from ...

How can I include comments in HTML? An HTML comment begins with "...

In below sample code if we create a object of class2 which constructor will fire first? Public Class...

How To Create an Add-to-NewsGator Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...

What does a special set of tags <?= and ?> do in a PHP script page? <?= express...