Search

MySQL Connector

MySQL Connector

Back Next

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) 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) Unsigned Bigint is not applicable.
Float	Decimal	Precision 1 to 28, scale 0 to 28
Double	Double	Precision 15 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)

Appendix A: Data type reference

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.