Special characters keep on breaking Talend DI

[JSey]

Hi

I have a script as such

MS SQL database ---> Tmap ---> Salesforce

In the MS SQL database, there are some special characters that keeps on breaking Talend (error out) as such:

’

•

·

Ø

In the database metadata, I have the text column with the data setup as string and db type nvarchar. Is there anything else I can be doing so that these characters stops breaking Talend?

[Anonymous]

Hello,

What's mssql DB version are you using?

For UTF-8 encoding with MSSQL Input, you can try to set Additional JDBC Parameter character Encoding=UTF-8 in advanced settings of tMSSqlInput component.

Best regards

Sabrina