Part III: Version 9.5.1 > Changes to Informatica Domain (9.5.1) > Datatype Mappings for MySQL
  

Datatype Mappings for MySQL

Effective in version 9.5.1, some datatype mappings have changed for the DataDirect ODBC MySQL driver.
The following table shows how the MySQL datatypes are mapped to the standard datatypes for ODBC 6.1 and ODBC 7.0:
MySQL Datatype
ODBC 6.1 Datatype for previous Informatica versions
ODBC 7.0 Datatype for Informatica 9.5.1
Tinyblob
binary(255)
longvarbinary(255)
Tinytext
varchar(255)
text(255)
Year2
date(10)
smallint(5)
Year4
date(10)
smallint(5)
Existing sources and targets keep the ODBC 6.1 datatype mappings. New sources and targets will use the ODBC 7.0 datatype mappings.