Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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