Manifold tables can utilize the following data types for fields.
boolean |
TRUE or FALSE, also expressed as 1 or 0 |
datetime |
A calendar date (day, month, year) and time (hour, minute, second, millisecond) ranging from January 3, 0001, 00:00:00.000 to December 31, 9999, 23:59:59.999 |
float32 |
32 bit floating point number with a range of 1.5 x 10-45 to 3.4 x 1038 |
float32x2 float32x3 float32x4 |
Vectorsof 2, 3 or 4 numbers, each of which is a float32 |
float64 |
64 bit floating point number with a range of 5.0 x 10-324 to 1.7 x 10308 |
float64x2 float64x3 float64x4 |
Vectors of 2, 3 or 4 numbers, each of which is a float64
|
geom geommfd |
Manifold geometry. geom is the native Manifold geometry type. geommfd is the equivalent written in binary for storage in external databases. |
geomwkb |
WKB geometry |
int8 |
8 bit signed integer for values from -128 to 127 |
int8x2 int8x3 int8x4 |
Vectors of 2, 3 or 4 numbers, each of which is an int8 |
int16 |
16 bit signed integer for values from -32,768 to 32,767 |
int16x2 int16x3 int16x4 |
Vectors of 2, 3 or 4 numbers, each of which is an int16 |
int32 |
32 bit signed integer for values from -2,147,483,648 to 2,147,483,647 |
int32x2 int32x3 int32x4 |
Vectors of 2, 3 or 4 numbers, each of which is an int32 |
int64 |
64 bit signed integer for values from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 |
int64x2 int64x3 int64x4 |
Vectors of 2, 3 or 4 numbers, each of which is an int64 |
nvarchar |
Variable length Unicode text using UNICODE UCS-2 character set, two bytes per character. 2 GB maximum storage size for a total of 1 GB characters. |
tile |
A Manifold array of numbers of specified size, such as 128 x 128, where each number in the array is an allowed Manifold numeric type, including vector numeric types such as uint8x3. |
uint8 |
8 bit unsigned integer for values from 0 to 255 |
uint8x2 uint8x3 uint8x4 |
Vectors of 2, 3 or 4 numbers, each of which is a uint8 |
uint16 |
16 bit unsigned integer for values from 0 to 65,535 |
uint16x2 uint16x3 uint16x4 |
Vectors of 2, 3 or 4 numbers, each of which is a uint16 |
uint32 |
32 bit unsigned integer for values from 0 to 4,294,967,295 |
uint32x2 uint32x3 uint32x4 |
Vectors of 2, 3 or 4 numbers, each of which is a uint32 |
uint64 |
64 bit unsigned integer for values from 0 to 18,446,744,073,709,551,615 |
uint64x2 uint64x3 uint64x4 |
Vectors of 2, 3 or 4 numbers, each of which is a uint64 |
uuid |
Universally Unique IDentifier (UUID), a 128 bit value represented by a text string of lower-case hexadecimal digits in standard form of groups of digits separated by hyphens. Each UUID is unique. |
varbinary |
Variable length binary data. Maximum storage size is 2 GB |
varchar |
Variable length non-Unicode text, one byte per character. 2 GB maximum storage size for a total of 2 GB characters. |