Supported Database Data Types for Spectrum Spatial - data_integration_1 - discovery - spectrum_platform - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
Overview
Reference
How Do I
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

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