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.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
