Binary large objects (BLOBs)

Binary large objects (BLOBs) are potentially very big (serevral GigaBytes) pieces of binary data which databases can store. Because of their potential size, they are not manipulated like any other data, and are usually not transfered when running a statement: first a reference to a blob is created for an existing or a new blob using a statement, and then that reference is used, after the statement has been executed, to get or set some parts of the blob.

Libgda makes its best to hide the complexity of this and most of the time blobs can be used like any other type of values with the following limitations: