Supported Database Data Types

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 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)×21023. 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-223)×2127. 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 -231 (-2,147,483,648) and 231-1 (2,147,483,647).
long
A numeric data type that contains both negative and positive whole numbers between -263 (-9,223,372,036,854,775,808) and 263-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 datatype 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:

Database Data Type Supported Data Type
Date/Time Types
TIMESTAMP datetime
String Types
CHAR string
CLOB string
LONGVARCHAR string
NCHAR string
NVARCHAR string
VARCHAR string
Numeric Types
BIGINT long
DECIMAL double
FLOAT double
NUMERIC bigdecimal
REAL float
SMALLINT integer
TINYINT integer
Boolean Types
BIT boolean