From the documentation (MySQL 8) :
Type | Maximum length -----------+------------------------------------- TINYTEXT | 255 (2 8−1) bytes TEXT | 65,535 (216−1) bytes = 64 KiB MEDIUMTEXT | 16,777,215 (224−1) bytes = 16 MiB LONGTEXT | 4,294,967,295 (232−1) bytes = 4 GiB
Note that the number of characters that can be stored in your column will depend on the character encoding.
Related Contents:
- How do I quickly rename a MySQL database (change schema name)?
- MyISAM versus InnoDB [closed]
- MySQL Query GROUP BY day / month / year
- How do I see all foreign keys to a table or column?
- How to shrink/purge ibdata1 file in MySQL
- MySQL DROP all tables, ignoring foreign keys
- How can I check MySQL engine type for a specific table?
- How to convert all tables from MyISAM into InnoDB?
- How to debug Lock wait timeout exceeded on MySQL?
- What’s the difference between MyISAM and InnoDB? [duplicate]
- Is there a REAL performance difference between INT and VARCHAR primary keys?
- MySQL InnoDB not releasing disk space after deleting data rows from table
- 1114 (HY000): The table is full
- Is there any performance gain in indexing a boolean field?
- What is InnoDB and MyISAM in MySQL?
- Bogus foreign key constraint fail
- UUID performance in MySQL?
- mysqldump exports only one table
- How do I know if a mysql table is using myISAM or InnoDB Engine?
- InnoDB: Error: log file ./ib_logfile0 is of different size
- MySQL InnoDB – innodb_file_per_table cons?
- Mysql crashed and won’t start up
- Best MySQL cache settings for 8gb RAM dedicated MySQL server using only InnoDB (5gb database)
- Modifying columns of very large mysql tables with little or no downtime
- Backing up a MySQL database via ZFS snapshots
- What is the difference between InnoDB and MyISAM?
- How to improve MySQL INSERT and UPDATE performance?
- How do you choose a MySQL database engine
- How to know storage engine used of a database?
- Simpler way to convert all tables from InnoDB to MyISAM
- How to disable keys in MySQL InnoDB tables?
- Setting a time limit for a transaction in MySQL/InnoDB
- Increase InnoDB buffer pool size
- MySQL AUTO_INCREMENT does not ROLLBACK
- #1025 – Error on rename of ‘./database/#sql-2e0f_1254ba7’ to ‘./database/table’ (errno: 150)
- MySQL InnoDB foreign key between different databases
- Force InnoDB to recheck foreign keys on a table/tables?
- Why is MySQL InnoDB insert so slow?
- How do I rename a MySQL database (change schema name)?
- Setting up table relations what do “Cascade”, “Set Null” and “Restrict” do?
- How to regex in a MySQL query
- Changing Table Engine in MySQL
- How to change value for innodb_buffer_pool_size in MySQL on Mac OS?
- How can I set default storage engine used by MySQL?
- MySQL: What is a page?
- How to improve INSERT INTO … SELECT locking behavior
- MySQL Integer vs DateTime index
- Why does MySQL autoincrement increase on failed inserts?
- Could not open mysql.plugin table. Some plugins may be not loaded
- InnoDB: Attempted to open a previously opened tablespace