Share via

BLOB Data Type in Dynamics NAV

  • Article

A binary large object (BLOB) is a complex data type. Variables of this data type differ from normal numeric and string variables in that BLOBs have a variable length.

The maximum size of a BLOB is 2 GB.

Remarks

Use BLOBs to store memos (text), pictures (bitmaps), or user-defined types.

Note

You cannot view text that is stored in BLOBs from the development environment.

You can read from and write to BLOBs by creating input and output streams, respectively. To do so, use CREATEINSTREAM Function (BLOB) and CREATEOUTSTREAM Function (BLOB).

For more information, see InStream and OutStream Data Types.

To optimize performance, when you access a record that has a BLOB field, the data in the BLOB is not always read into memory. You must call the CALCFIELDS Function (Record) to read the BLOB into memory and calculate it. Then you can use the BLOB in C/AL code or display it in the application.

It is not supported to insert a BLOB field into a Variant.

It is not supported for a page to access a BLOB field from a table other than the SourceTable of the page.

Different Behavior in Versions Prior to Microsoft Dynamics NAV 2013

In product versions earlier than Microsoft Dynamics NAV 2013, if you wrote to a BLOB OutStream but did not insert or modify the record in the database, and then called the CALCFIELDS function on the BLOB field, you would get the value of the BLOB based on what you wrote to the OutStream, not based on what was currently in the database.

In versions Microsoft Dynamics NAV 2013 and later, for the same scenario, you get the value of the BLOB that is in the database. Similarly, if you call the CALCFIELDS Function on a new record that has not been inserted into the database, then you clear the BLOB field from the record.

See Also

CREATEINSTREAM Function (BLOB)
CREATEOUTSTREAM Function (BLOB)
EXPORT Function (BLOB)
HASVALUE Function (BLOB)
Variant Data Type