MySQL Connector > Data type reference > MySQL and transformation data types
  

MySQL and transformation data types

The following table lists the MySQL data types that Data Integration supports and the corresponding transformation data types:
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 supported.
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 supported.
Float
Decimal
Precision 1 to 28, scale 0 to 28
Double
Double
Precision 15
Note: Unsigned Double is not supported.
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)