Application Integration
- Application Integration
- All Products
JDBC Data Type
| Transformation Data Type
| Range
|
---|---|---|
BIGINT
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
BINARY
| Binary
| 1 to 104,857,600 bytes
|
BIT
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
BLOB
| Binary
| 1 to 104,857,600 bytes
|
BOOLEAN
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
CHAR
| String
| 1 to 104,857,600 characters
|
CLOB
| Text
| 1 to 104,857,600 characters
|
DATE
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
DECIMAL
| Decimal
| Precision 1 to 28, scale 0 to 28
|
DOUBLE
| Double
| Precision 15
|
FLOAT
| Double
| Precision 15
|
INTEGER
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
LONGVARBINARY
| Binary
| 1 to 104,857,600 bytes
|
LONGVARCHAR
| Text
| 1 to 104,857,600 characters
|
NUMERIC
| Decimal
| Precision 1 to 28, scale 0 to 28
|
REAL
| Double
| Precision 15
|
SMALLINT
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
TIME
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
TIMESTAMP
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
TINYINT
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
VARBINARY
| Binary
| 1 to 104,857,600 bytes
|
VARCHAR
| String
| 1 to 104,857,600 characters
|