Give example for binary datatype non binary datatype?

Editorial / Best Answer

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 - 1 of 1 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

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions