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 |