- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
What is the maximum length of data we can put in a TEXT column in MySQL?
As we know TEXT data objects are useful for storing long-form text strings. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. The following table shows the storage of different kinds of TEXT data type −
| Type of BLOB | Maximum amount of Data that can be stored | Overhead |
| TINYTEXT | Up to 255 bytes | 1 byte |
| TEXT | Up to 64 Kb | 2 bytes |
| MEDIUMTEXT | Up to 16 Mb | 3 bytes |
| LONGTEXT | Up to 4 Gb | 4 bytes |
- Related Articles
- What is the maximum length of data we can put in a BLOB column in MySQL?
- How can we put comments in a column of existing MySQL table?
- What is the maximum length of MySQL VARCHAR column?
- How can we change the data type of the column in MySQL table?
- What is the maximum length of a table name in MySQL?
- What is TEXT data type in MySQL?
- What is the maximum length of each type of identifier in MySQL?
- Can we GROUP BY one column and select all data in MySQL?
- How can we export all the data from MySQL table into a text file?
- How can we retrieve the length of a specified string in MySQL?
- How can we get some last number of characters from the data stored in a MySQL table’s column?
- How can we get some starting number of characters from the data stored in a MySQL table’s column?
- How can we upload the changed value, rather than written in a text file, of column(s) while importing that text file into MySQL table?
- How can we put schedule for different kinds of MySQL events?
- How can we extract a substring from the value of a column in MySQL table?
Advertisements