topic Re: Data truncation: Data too long for column in Talend Studio

Data truncation: Data too long for column

Anonymous — Tue, 07 Oct 2014 07:02:30 GMT

Greetings,
I've try this simple jobs (in the pics), and i have this error:
Data truncation: Data too long for column 'nom' at row 1

Best regards,
G47

Re: Data truncation: Data too long for column

Anonymous — Tue, 07 Oct 2014 07:07:26 GMT

When i put the precision to 100, i don't have error however the table still empty.

Re: Data truncation: Data too long for column

Anonymous — Tue, 07 Oct 2014 08:57:08 GMT

Hi,
What is the datatype of column and present setting in tMap output and source?
Vaibhav

Re: Data truncation: Data too long for column

Anonymous — Tue, 07 Oct 2014 08:58:27 GMT

hi G47,
first about "data too long" , as error said, you try to insert data in your table.
(Again) it's not a good thing to increase length indefinitely ... you have to profile data sources to understand them
Never mind, in your case, as you are using a shared connection (tmysqlconnection) , you create transaction .. so you have to manage commit & rollback (or check commit automaticaly in advanced parameters)
be aware that if you use a 'extended insertion', and having some data truncation, you lost not only line containing too long data , but the entire 'block'.
hope it helps
regards
laurent

Re: Data truncation: Data too long for column

Anonymous — Sat, 08 Nov 2014 16:14:24 GMT

Thank you it helps me a lot