topic Re: Special Character issue in Talend in Talend Studio

Special Character issue in Talend

Anonymous — Thu, 12 Apr 2018 04:16:19 GMT

Hi ,

I developed a job in talend which loads data into specific tables from excel and excel has some % values in it.But while loading the data into it DB, if data has special characters (%,- )in some field like Amount , the actual amount is converting to zero.Could you please help how to solve this?

Re: Special Character issue in Talend

TRF — Thu, 12 Apr 2018 07:02:24 GMT

Hi,
Seems these fields are string datatype (else, how can they contain something else than digits?)
What is the datatype on database side?
Do you have any before insert trigger for the target table?

Re: Special Character issue in Talend

mks02 — Thu, 12 Apr 2018 09:43:14 GMT

Can you confirm the excel-sheet and DB table data type for these amount and actual amount fields?

In general if you have string data type for excel and in DB you are using nvarchar, it will not show any zero amount or blank value.