Switch to: V9V8V7V6V5

Valentina Field Overview

Each Valentina Table has one or more fields (columns).

Valentina provides the following types of fields:

Type Size in Table Range
Boolean 1 bit 0, 1, NULL
Byte 1 byte 0..255
Enum,Enum8 1 byte up to 255 enumerated values
Enum16 2 bytes up to 65535 enumerated values
Short 2 bytes -32768..32767
UShort 2 bytes 0..65535
Medium 3 bytes -8388608..8388607
UMedium 3 bytes 0..16777215
Long 4 bytes -2147483647..2147483647
ULong 4 bytes 0..4294967295
LLong 8 bytes -2(64-1)..+2(64-1)
ULLong 8 bytes 0..264
Float 4 bytes ± (3.4-38..3.438)
Double 8 bytes ± (1.7-308..1.7308)
Date 4 bytes any date between -222 ..222 years
Time 4 bytes any time
DateTime 8 bytes conjunction of Date and Time
String 1..65535 characters string of fixed length
VarChar 1..4088 bytes string of variable length
FixedBinary 1..65535 bytes binary data of fixed length
VarBinary 1..4096 bytes binary data of variable length
BLOB up to 2 GB any binary data
Text up to 2 GB text
ObjectPtr 4 bytes RecID of pointed record
RecID 4 bytes RecID of a record
OID 8 bytes OID of a record