data types
A data type defines the limits of a data field in a BIRT Analytics database. For example, the BIRT Data Analytics demo database includes the data types listed in Table G‑2.
Table G‑2 Data types in BIRT Analytics Loader
Data type
Description
Date
Contains numbers that represent day, month, and year. The default format is mm_dd_yyyy.
Datetime
Date and time data from January 1, 1753, through December 31, 9999, providing accuracy to three-hundredths of a second, or 3.33 milliseconds. The default format is yyyy_mm_dd_hh_MM_ss.
Integer
Integer data from -2^31 (-2,147,483,648) through 2^31‑1 (2,147,483,647).
Longint
Integer data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).
Real
Floating precision number data with the following valid values:
-3.40E+38 through -1.18E‑38, 0 and 1.18E‑38 through 3.40E+38.
String
A sequence of ASCII characters.
Time
Contains a value representing time of day. The default format is hh_MM_ss.
Unicode
A sequence of characters based on consistent encoding, representation, and handling of text as expressed in global writing systems.
Related terms
Data Explorer, data field, Data Tree, record