Data Types

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.

 

 

Tooltips on table column headers will show the name of the field as well as the data type:

 

il_table_column_tooltip.png

 

 

Notes

Computed fields - Fields in tables can be computed fields, which automatically calculate a value for the field based on an expression.   See the Example: Add a Computed Field to a Table topic for a step by step example.

 

See Also

Tables

 

Editing Tables

 

Indexes

 

Add an Index to a Table

 

Queries

 

Spatial Data