ETL from MSSQL to MariaDB (nvarchar datatype)

[Anonymous]

Hi all.... im just getting started with Talend Open Studio and i've come across the following issue with ETL from MSSQL to MariaDB.
Columns with datatype nvarchar is been transferred as varchar.

[Anonymous]

Hi,
Is there any exception in your job during the ETL processing? Can you post the error message printed on console into forum?
Best regards
Sabrina

[Anonymous]

There are no errors since i have not yet populated the table with data... but the data type varchar on the target instead of nvarchar 
Regards
Chris

[Anonymous]

Hi,
There is no "nvarchar" data type in tmysqloutput component.
In Talend; the Mapping between DataType from the Database and TalendType can be customize to fit and match with your need.
In your Studio, you can open the Preferences (go to the Menu, choose Window and then Preferences ); dig into Talend > Specific settings > Metadata of Talend.
Best regards
Sabrina