MySQL Data Type | Transformation Data Type | Description |
|---|---|---|
Char | String | 1 to 104,857,600 characters |
Varchar | String | 1 to 104,857,600 characters |
Boolean | Integer | -2,147,483,648 to 2,147,483,647 (Precision 10, scale 0) |
TinyInt | Integer | -2,147,483,648 to 2,147,483,647 (Precision 10, scale 0) |
SmallInt | Integer | -2,147,483,648 to 2,147,483,647 (Precision 10, scale 0) |
MediumInt | Integer | -2,147,483,648 to 2,147,483,647 (Precision 10, scale 0) |
Int | Integer | -2,147,483,648 to 2,147,483,647 (Precision 10, scale 0) Note: Unsigned Int is not applicable. |
Bigint | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (Precision 19, scale 0) Note: Unsigned Bigint is not applicable. |
Float | Decimal | Precision 1 to 28, scale 0 to 28 |
Double | Double | Precision 15 Note: Unsigned Double is not applicable. |
Decimal | Decimal | Precision 1 to 28, scale 0 to 28 |
Date | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (Precision to the nanosecond) |
Datetime | 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) |