Page History

...

Type	Field Size	Default Value	Description
Int8	1	`0`	1-byte signed integer
Int16	1, 2	`0`	2-byte signed integer, but may occupy less space due to compression mechanism described below
Int32	1, 2, 4	`0`	4-byte signed integer, but may occupy less space due to compression mechanism described below
Int64	1, 2, 4, 8	`0`	8-byte signed integer, but may occupy less space due to compression mechanism described below
Float	4	`0.0`	4-byte floating-point number
Double	4, 8	`0.0`	8-byte floating-point number, but may occupy less space due to compression mechanism described below
Number	variable	`0`	Variable-length integer
Decimal	variable	`0`	Variable-length fixed-point number, the scale is determined by the schema though it is stored with the number
UUID	16	`00000000-0000-0000-0000-000000000000`	UUID
String	variable	empty string	An utf-8 encoded string
Binary	variable	empty binary	Variable-length arbitrary binary data
Bitmask	variable	empty bit-string	Variable-length binary data representing a bit-string
Date	3	`Jan 1, 1 BC` (1 BC immediately precedes 1 AD in the Gregorian calendar)	A timezone-free date (a year, month, day)
Time	4, 5, 6	`00:00:00.000000`	A timezone-free time (hour, minute, second, microseconds)
DateTime	7, 8, 9	`Jan 1, 1 BC, 00:00:00.000000`	A timezone-free datetime encoded as (date, time)
Timestamp	8, 12	`Jan 1, 1970, 00:00:00.000000`	Number of microseconds since Jan 1, 1970 00:00:00.000000 (with no timezone)
Duration	8, 12	`0` (PT0S)	See below
Period	3, 6, 12	`0` (P0D)	See below
Boolean	1	`false`	A boolean value (either `true` of `false` )

All integer values are stored in the little-endian byte order.

...

Page tree