What Are The Differences Between BINARY And VARBINARY
Posted by Mary
25 Jan, 2012
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.
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.
Comments Received:
Please give your suggestions and feedback: