"Data truncation: Data too long for column" causes

[Anonymous]

I created a MySql table using talend. And with tfileInputDelimited palette, i tried to copy the data present in csv filoe to the table in data base.

While runnung the job, am getting Data truncation: Data too long for column 'First' at row 1 

Please help me in resolving the issue. I am still at learning phase.

Please find the screenshots attached for more details.

Thank u.

[Anonymous]

problem found in table definition

thanks TRF and all who helped me

But want to know the reason behind this error occurrence? 

[TRF]

Great!

We can't tell you th reason as we are not in the process you follow to create the table.

Probably one or many columns are smaller than the data you're trying to inject.

[Anonymous]

Thanks buddy

[sam473]

Can someone help me, me also faced the same issue I have delimited file of 100 rows I want to inject those 100 rows into my SQL   but I am facing an error as Data truncation: Data too long for column 'first name' at row 1. attached images for better understanding can some say the root cause of this error to avoid next time ,expecting a quick response from someone who can help me. 

error.JPG
jobdesign.JPG
output.JPG
src&targetschema.JPG
SRC_FILE.JPG

[sam473]

Can someone help me, me also faced the same issue I have delimited file of 100 rows I want to inject those 100 rows into my SQL   but I am facing an error as Data truncation: Data too long for column 'first name' at row 1. attached images for better understanding can some say the root cause of this error to avoid next time ,expecting a quick response from someone who can help me.