MySQL - Maximum size of TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT?

Here's the difference in maximum storage size of each datatype:

Type Maximum size
TINYTEXT 255 (2^8−1) bytes
TEXT 65,535 (2^16−1) bytes = 64 KB
MEDIUMTEXT 16,777,215 (2^24−1) bytes = 16 MB
LONGTEXT 4,294,967,295 (2^32−1) bytes = 4 GB

TablePlus is a native client for MySQL, PostgreSQL, SQLite, Microsoft SQL Server, and other databases. You can keep several databases open at once.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.

TablePlus GUI Tool MySQL

← All posts