MySQL Forums
Forum List  »  Quality Assurance

Regarding Error code : 1406 : Data Truncation : Data too long for column
Posted by: Vivek Kumar Sharma
Date: August 14, 2020 01:16AM

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.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.