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 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^{1023}. 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^{23})×2^{127}. 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^{31} (-2,147,483,648) and 2^{31}-1 (2,147,483,647).
- long
- A numeric data type that contains both negative and positive whole numbers between -2^{63} (-9,223,372,036,854,775,808) and 2^{63}-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:
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 |