Table of Contents
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.
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;