Page History

...

Type	Size	Description
Bitmask(n)	⌈n/8⌉ bytes	A fixed-length bitmask of n bits
Int8	1 byte	1-byte signed integer
Uint8	1 byte	1-byte unsigned integer
Int16	2 bytes	2-byte signed integer
Uint16	2 bytes	2-byte unsigned integer
Int32	4 bytes	4-byte signed integer
Uint32	4 bytes	4-byte unsigned integer
Int64	8 bytes	8-byte signed integer
Uint64	8 bytes	8-byte unsigned integer
Float	4 bytes	4-byte floating-point number
Double	8 bytes	8-byte floating-point number
Number([n])	Variable	Variable-length number (optionally bound by n bytes in size)
Decimal	Variable	Variable-length floating-point number
UUID	16 bytes	UUID
String	Variable	A string encoded with a given Charset
Date	3 bytes	A timezone-free date encoded as a year (15 bits), month (4 bits), day (5 bits)
Time	4 bytes	A timezone-free time encoded as padding (5 bits), hour (5 bits), minute (6 bits), second (6 bits), millisecond (10 bits)
Datetime	7 bytes	A timezone-free datetime encoded as (date, time)
InstantTimestamp	8 bytes	Number of milliseconds since Jan 1, 1970 00:00:00.000 (with no timezone)
BLOB	Variable	Variable-size byte array

...

Field	Size
Schema version	2 bytes
Flags	1 2 byte
Key columns hash	4 bytes
Key columns:
Key columns full size	2 (3?) 4 bytes
Key columns varsize columns offsets table size	2 bytes
Key columns varsize columns offsets table	Variable (number of non-null non-default varsize columns * 2(3?)4)
Key columns null-defaults map	⌈number of columns / 8⌉
Key columns fixed size values	Variable
Key columns variable size values	Variable
Value columns:
Value columns full size	2 (3?) 4 bytes
Value columns varsize columns offsets table size	2 bytes
Value columns varsize columns offsets table	Variable (number of non-null non-default varsize columns * 2(3?)4)
Value columns null-defaults map	⌈number of columns / 8⌉
Value columns fixed size values	Variable
Value columns variable size values	Variable

...

Page tree