Switch to: V9V8V7V6V5

VarBinary Field

Range of Type

This type of field can effectively store binary values (i.e. values that contain zero-bytes inside) of variable size with limit up to 4088 bytes per value.

Storage

It is easy to see that VarBinary field is similar to VarChar Field by storage type. This field uses a logical file of page structure to be able effectively store strings of variable length. Read more...

Flags

  • fNullable

This field can be declared as Nullable. In this case a special bitmap is associated with this field.

Read Mode About Field Flags

API

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

SQL

At SQL Level you can create such field using

CREATE TABLE T1( fldVarBinary VARBINARY(1000) );

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

SELECT * FROM T1 WHERE fldVarBinary = 'abcdef';