Data types

Name	Description	Length constraints
INTEGER	Signed 64-bit integer value. Usually referred to as BIGINT in other databases.	-
BOOLEAN	A boolean value, either TRUE or FALSE	-
VARCHAR	UTF8-encoded text	Maximum number of bytes in the UTF-8 encoded representation of the string
BLOB	sequence of bytes	Maximum number of bytes in the sequence
TIMESTAMP	datetime value with microsecond precision	-

Size constraints

Size constraint is specified with a [MAX_SIZE] suffix on the type, e.g. BLOB[16] represents a sequence of up to 16 bytes.

NULL values

NULL values in immudb are not unique - two NULL values are considered equal on comparisons.

Timestamp values

Timestamp values are internally stored as a 64-bit signed integer being a number of microseconds since the epoch time. Those values are not associated with any timezone, whenever a conversion is needed, it is considered to be in UTC.