There are two data types in the database component schema: the Talend type and the DB type. When retrieving the table schema, there is always a default Talend type to map to the real DB type. Also, there is a default DB type to map to the Talend type on the DB schema, when linking a non-DB component to a DB output component. You can modify the default data type mapping for your project rather than changing it manually every time.
This procedure was written with:
Talend Open Studio for Data Integration 5.0.0
Sun JDK build 1.6.0_26-b03
Windows XP SP3
Talend verified this procedure to be compatible with:
Talend Open Studio for Data Integration releases: 4.2.3, 4.2.4, 5.0.0, 5.0.1, 5.0.2, 5.1.1
A Talend type is an intermediate Java type, mapped for each data type of different databases. These default data type mappings are configured in an XML file. Each kind of database has a separate mapping configuration file. For example, the file mapping_Mysql.xml maps MySQL data types to Talend types.
A portion of the mapping for a MySQL database is as follows. The DB type DECIMAL will map to the Talend type Float by default when retrieving the table schema.