Supported Database Data Types for Spectrum Spatial
These database data types are automatically mapped to one of the supported data types for Spectrum Spatial.
| 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 |