Switch to: V9V8V7V6V5

BLOB Field

Range of Type

This type of field can effectively store large binary values (i.e. values that can not be treated as strings). There is no size limit while VarBinary has limit 4088 bytes per value.

Storage

This field uses a logical file of segment structure to be able effectively store binary values of variable length. Read more...

Flags

  • fNullable

This field always can be considered as Nullable because ZERO value in the ULONG-file can play role of NULL value.

Read Mode About Field Flags

API

This field type is represented at the API level by VBLOB Class.

SQL

At SQL Level you can create such field using

CREATE TABLE T1( fldBLOB BLOB(512) );

You can use this field in any predicate expression, e.g.

SELECT * FROM T1 WHERE fldBLOB IS NULL;