Supported Database Data Types for the Location Intelligence Module

These database data types are automatically mapped to one of the supported data types for the Location Intelligence Module.

Database Data Type Supported Data Type
SQL Server
tinyint SHORT_INTEGER
smallint SHORT_INTEGER
int INTEGER
bigint LONG_INTEGER
float DOUBLE
real DOUBLE
decimal(10, 5) DOUBLE
numeric(10, 5) DOUBLE
date DATE
time TIME
datetime DATE_TIME
smalldatetime DATE_TIME
char(10) STRING
varchar(10) STRING
nchar(10) STRING
nvarchar(10)G STRING
binary(10) BINARY
varbinary(10) BINARY
 
PostGIS
smallint SHORT_INTEGER
integer INTEGER
bigint LONG_INTEGER
numeric(10, 5) DOUBLE
real DOUBLE
double precision DOUBLE
serial INTEGER
bigserial LONG_INTEGER
bytea BINARY
date DATE
time TIME
timestamp DATE_TIME
character(10) STRING
character varying(10) STRING
nchar(10) STRING
 
Oracle
NUMBER DOUBLE
CHAR(10) STRING
VARCHAR(10) STRING
VARCHAR2(10) STRING
NCHAR(10) STRING
NVARCHAR2(10) STRING
DATE DATE_TIME
TIMESTAMP DATE_TIME
BLOB BINARY