Generic SQL type | Facets | Description | Actuate SQL type |
BIT | 1-bit integer, with value 1 or 0. | INTEGER | |
TINYINT | 8-bit integer. | INTEGER | |
SMALLINT | 16-bit integer. | INTEGER | |
INTEGER | 32-bit integer. | INTEGER | |
BIGINT | 64-bit integer. | DECIMAL | |
FLOAT | Size | Floating point that can vary between single and double binary precision, depending on the value of size. | DOUBLE |
REAL | Floating point (single binary precision). | DOUBLE | |
DOUBLE | Floating point (double binary precision). | DOUBLE | |
NUMERIC | Size, decimals | Decimal with scale decimals, and precision that cannot exceed size. | DECIMAL |
DECIMAL | Size, decimals | Same as NUMERIC. | DECIMAL |
CHAR | Size | Fixed-width character, maximum length is specified by size. | VARCHAR |
VARCHAR | Size | Variable-width character, maximum length is specified by size. | VARCHAR |
LONGVARCHAR | Size | Long variable-width character. Maximum length is specified by size. The Integration service does not support strings with a maximum length of more than 64,000 characters. | VARCHAR |
DATE | Date with no time component. | TIMESTAMP | |
TIMESTAMP | Date with time component, with or without fractions-of-a-second field, containing up to 3 digits. | TIMESTAMP |