Blob Data Type

To store binary data of any kind, such as ASCII text, an executable (.exe) file, or a stream of bytes, and with indeterminate length, use the Blob data type. Blob data types are particularly useful for storing Image data from SQL Server.

You can assign values to a Blob field using binary literals. Binary literals begin with a prefix, 0h, followed by a string of hexadecimal numbers and are not enclosed with quotation marks (""), unlike character strings. The following list includes examples of binary literals:

  • 0h202020

  • 0h6ABCDEF

  • 0h (empty binary literal)

Binary literals are limited to 255 encoded bytes.

To store binary values of fixed length, use the Varbinary data type instead. For more information, see Varbinary Data Type.

Expand imageSupport for Blob Data Type

Expand imageSee Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic