Amazon Aurora Connector Guide > Data Type Reference > Amazon Aurora and Transformation Data Types
  

Amazon Aurora and Transformation Data Types

The following table lists the Amazon Aurora data types that Informatica Cloud supports and the corresponding transformation data types:
Amazon Aurora Data Type
Transformation Data Type
Description
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
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)
DECIMAL
Decimal
Precision 1 to 28, scale 0 to 28
DOUBLE
Double
Precision 15
ENUM
String
1 to 104,857,600 characters
FLOAT
Double
Precision 15
INT
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
LONGBLOB
Binary
1 to 104,857,600 bytes
LONGTEXT
String
1 to 104,857,600 characters
MEDIUMBLOB
Binary
1 to 104,857,600 bytes
MEDIUMTEXT
String
1 to 104,857,600 characters
SET
String
1 to 104,857,600 characters
SMALLINT
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
TEXT
String
1 to 104,857,600 characters
TIME
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
TINYBLOB
binary
1 to 104,857,600 bytes
TINYINT
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
TINYTEXT
String
1 to 104,857,600 characters
VARBINARY
Binary
1 to 104,857,600 bytes
VARCHAR
String
1 to 104,857,600 characters
YEAR
String
1 to 104,857,600 characters