Regarding Error code : 1406 : Data Truncation : Data too long for column

[Vivek Kumar Sharma]

Hello,

I have an error saying
Regarding Error code : 1406 : Data Truncation : Data too long for column

scenario:
version: 8.0.19

I am fetching data from federated table (source),


source:

column length is varchar(50).
I have 1 record in this table at id say 517 with length 50.
ENGINE=FEDERATED DEFAULT CHARSET=utf8

Destination:
column length is varchar(50).
ENGINE=InnoDB DEFAULT CHARSET=utf8

Issue:

when i read data from source and insert in destination table in range say rows from 515 to 518, it give error: Error code : 1406 : Data Truncation : Data too long for column and showing error in data at ID=517.

but if I insert data specific for ID=517, it inserted without any error.

I am using strict mode and tried with removing strict mode with
SET @@global.sql_mode= '';
but same error.

what could be the issue and how to solve it.