What Are the Differences between BINARY and VARBINARY
Q
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics
✍: 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.
2007-05-11, 5230👍, 0💬
Related Topics:
