Question mark '?' when inserting string with special characters

[Tech8]

When i try to insert or update a string with characters like 'ñ' or 'ß' the data is changed automatically to a '?'. It happens with a lot of characters but it's not happening every time.

Is it something related to the database or there is something i can do to avoid it when using talend?

[TRF · Accepted solution]

It may come from the character set used on database side or from the character set used for input files if any