You can set the parameters for type conversion in Talend Studio, from Java towards databases and vice versa.
From the menu bar, click Window > Preferences to display the [Preferences] dialog box.
Expand the Talend and Specific Settings nodes in succession and then click Metadata of Talend Type to display the relevant view.
The Metadata Mapping File area lists the XML files that hold the conversion parameters for each database type used in Talend Studio.
You can import, export, or delete any of the conversion files by clicking Import, Export or Remove respectively.
You can modify any of the conversion files according to your needs by clicking the Edit button to open the [Edit mapping file] dialog box and then modify the XML code directly in the open dialog box.