MySQL Forums
Forum List  »  Quality Assurance

Re: Regarding Error code : 1406 : Data Truncation : Data too long for column
Posted by: Peter Brawley
Date: August 14, 2020 08:31AM

With utf8 in MySQL, one char can use up to three bytes. With utf8mb4, up to four. So for 50 chars you need varchar(200).

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.