Diese Datenbank-Datentypen werden automatisch einem der unterstützten Datentypen für Spectrum Spatial zugeordnet.
Datenbank-Datentyp | Unterstützter Datentyp |
---|---|
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 |