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 |
SAP HANA | |
tinyint | SHORT_INTEGER |
smallint | SHORT_INTEGER |
integer | INTEGER |
bigint | LONG_INTEGER |
smalldecimal | DOUBLE |
decimal(10, 5) | DOUBLE |
real | DOUBLE |
double | DOUBLE |
float(30) | DOUBLE |
varchar(30) | STRING |
nchar(10) | STRING |
nvarchar(30) | STRING |
alphanum(30) | STRING |
date | DATE |
time | TIME |
seconddate | DATE_TIM |
timestamp | DATE_TIM |
varbinary(30) | BINARY |