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

Popular Posts:

How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...

How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...

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

What is test metrics? Test metrics accomplish in analyzing the current level of maturity in testing ...

Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...