Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
When i put the precision to 100, i don't have error however the table still empty.
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
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