MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

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).

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

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.