How does MySQL handle text that exceeds the maximum length of a database field?

When text exceeds the maximum length of a database field in MySQL, it will either be truncated to fit within the field's limit or an error will be thrown depending on the MySQL configuration. To handle this issue, you can check the length of the text before inserting it into the database and either truncate it to fit within the field's limit or handle the error gracefully. 

$text = "This is a long text that exceeds the maximum length of the database field.";
$max_length = 50;

if(strlen($text) > $max_length){
    $text = substr($text, 0, $max_length);
}

// Insert $text into the database

Keywords

MySQL text truncation database field length error handling data validation

Related Questions