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?
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.
