Switch to: V9V8V7V6V5

Byte Field

Range of Type

This type of field can keep values in the range 0..255.

Storage

This field always uses 1 byte on disk per value.

Flags

  • fNullable

BYTE field can be declared as Nullable.

  • fIndexed

This field can have flag fIndexed.. For a BYTE field Valentina uses a special kind of index, which is highly optimized for this range of values.

  • fUnique

This flag do not have sense for BYTE field, because then you will be able to have in the table only 255 records (except NULL records).

Read Mode About Field Flags

API

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

SQL

At SQL Level you can create such field using

CREATE TABLE T1( fldByte BYTE );

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

SELECT * FROM T1 WHERE fldByte = 54;