Supported Types and Data Structures
OmniSciDB supports many data types but not all of them are supported by the Remote Backend Compiler.
Scalar types
Datatype
Size (bytes)
Notes
BOOLEAN
1
TRUE: 'true'
, '1'
, 't'
. FALSE: 'false'
, '0'
, 'f'
. Text values are not case-sensitive.
TINYINT
1
Minimum value: -127
; maximum value: 127
SMALLINT
2
Minimum value: -32,767
; maximum value: 32,767
INT
4
Minimum value: -2,147,483,647
; maximum value: 2,147,483,647
.
BIGINT
8
Minimum value: -9,223,372,036,854,775,807
; maximum value: 9,223,372,036,854,775,807
.
Array
RBC also supports Array<T>
where T
is one of the following scalar types seen above. Both fixed and variable length arrays are supported in RBC. For more information, see the Array page.
Column
ColumnList
Cursor
Last updated
Was this helpful?