Data truncation: Data too long for column

One Star G47
One Star

Data truncation: Data too long for column

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
One Star G47
One Star

Re: Data truncation: Data too long for column

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


Four Stars

Re: Data truncation: Data too long for column

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

Re: Data truncation: Data too long for column

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 Smiley Wink
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
One Star G47
One Star

Re: Data truncation: Data too long for column

Thank you it helps me a lot