What is the difference between using the MySQL data types TEXT and LONGTEXT for storing long text data?

When storing long text data in MySQL, it is important to choose the appropriate data type to ensure efficient storage and retrieval. The main difference between TEXT and LONGTEXT data types is the maximum storage capacity. TEXT can store up to 65,535 bytes of data, while LONGTEXT can store up to 4,294,967,295 bytes. Therefore, if you need to store very long text data, it is recommended to use the LONGTEXT data type. 

// Using LONGTEXT data type to store long text data in MySQL
$sql = "CREATE TABLE long_text_data (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    long_text LONGTEXT
)";
$conn->query($sql);

// Inserting long text data into the table
$longTextData = "This is a very long text...";
$sql = "INSERT INTO long_text_data (long_text) VALUES ('$longTextData')";
$conn->query($sql);

// Retrieving long text data from the table
$sql = "SELECT long_text FROM long_text_data WHERE id = 1";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$retrievedLongText = $row['long_text'];
echo $retrievedLongText;

Keywords

MySQL data types TEXT LONGTEXT storing

Related Questions