Give example for binary datatype non binary datatype?

Interview Candidate
Oct 3rd, 2006
3
4793

Editorial / Best Answer

suji

Profile Answers by suji Questions by suji

Member Since Sep-2005 | Nov 6th, 2011

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes. varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes. image variables store up to 2 gigabytes of data and are commonly used to store any type of data file. Rest of the data types are non-binary

Showing Answers 1 - 3 of 3 Answers

krishnakumar

Nov 2nd, 2006

The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc

suji
Profile Answers by suji Questions by suji

Nov 6th, 2011

Here are the Binary data types in sql server - bit, binary, varbinary, image.

Bit variables store a single bit with a value of 0, 1 or NULL.

binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes.

varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes.

image variables store up to 2 gigabytes of data and are commonly used to store any type of data file.

Rest of the data types are non-binary