Supported Database Data Types - data_integration_1 - discovery - spectrum_platform - 23.1

Spectrum Technology Platform supports these data types commonly used in databases:

bigdecimal

A numeric data type that supports 38 decimal points of precision. Use this data type for data that will be used in mathematical calculations requiring a high degree of precision, especially those involving financial data. The bigdecimal data type supports more precise calculations than the double data type.

boolean

A logical type with two values: true and false.

date

A data type that contains a month, day, and year. For example, 2012-01-30 or January 30, 2012. You can specify a default date format in Spectrum Management Console.

datetime

A data type that contains a month, day, year, and hours, minutes, and seconds. For example, 2012/01/30 6:15:00 PM.

double

A numeric data type that contains both negative and positive double precision numbers between 2^-1074 and (2-2^-52)×2¹⁰²³. In E notation, the range of values is -1.79769313486232E+308 to 1.79769313486232E+308.

float

A numeric data type that contains both negative and positive single precision numbers between 2^-149 and (2-2²³)×2¹²⁷. In E notation, the range of values -3.402823E+38 to 3.402823E+38.

integer

A numeric data type that contains both negative and positive whole numbers between -2³¹ (-2,147,483,648) and 2³¹-1 (2,147,483,647).

long

A numeric data type that contains both negative and positive whole numbers between -2⁶³ (-9,223,372,036,854,775,808) and 2⁶³-1 (9,223,372,036,854,775,807).

string

A sequence of characters.

time

A data type that contains the time of day. For example, 21:15:59 or 9:15:59 PM.

Raw

An Oracle data type for storing variable length binary data. Maximum size is 2000 bytes (the maximum length in Oracle 7 was 255 bytes).

Other database data types are automatically mapped to one of the supported data types as follows: