What Are The Differences Between BINARY And VARBINARY

What Are The Differences Between BINARY And VARBINARY


  • 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.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.