Primitive Data Types
SQreamDB compresses all columns and types. The data size noted is the maximum data size allocation for uncompressed data.
Name |
Description |
Data Size (Not Null, Uncompressed) |
Example |
Alias |
---|---|---|---|---|
|
Boolean values ( |
1 byte |
|
|
|
Unsigned integer (0 - 255) |
1 byte |
|
NA |
|
Integer (-32,768 - 32,767) |
2 bytes |
|
NA |
|
Integer (-2,147,483,648 - 2,147,483,647) |
4 bytes |
|
|
|
Integer (-9,223,372,036,854,775,808 - 9,223,372,036,854,775,807) |
8 bytes |
|
|
|
Floating point (inexact) |
4 bytes |
|
NA |
|
Floating point (inexact) |
8 bytes |
|
|
|
Variable length string - UTF-8 unicode |
Up to |
|
|
|
38 digits |
16 bytes |
|
|
|
Date |
4 bytes |
|
NA |
|
Date and time pairing in UTC |
8 bytes |
|
|