Page History

...

Integer Field Compression

This is optional  and  subject to discussion.

Uniform use of offset tables for all fields lets us take advantage of variable-length principle for integer fields.

...

In SQL standard there are no unsigned integers. So their support may be omitted. But should it become needed for some reason then a compressed unsigned integer must be zero-extended on decompression.

UUID Representation

A UUID value occupies 16 bytes. It is encoded with a slight twist. It is split into two 8-byte integers – the most significant and least significant ones. The most significant goes first, the least significant goes after it. But each of these integers is stored in little-endian byte order. So a UUID 00112233-4455-6677-8899-aabbccddeeff will be encoded as byte sequence 77 66 55 44 33 22 11 00 ff ee dd cc bb aa 99 88.

Date Representation

A date field occupies 3 bytes.

...