Maximum length for MySQL TEXT data types

MySQL supports 4 TEXT data types, TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT.

TEXT data types are also able to store much more data than VARCHAR and CHAR text types so TEXT types are what you need to use when storing large amount of content in a database table.

The maximum amount of data that can be stored in TEXT data types are as follows:

TINYTEXT 256 bytes
TEXT 65,535 bytes (64kb)
MEDIUMTEXT 16,777,215 bytes (16MB)
LONGTEXT 4,294,967,295 bytes (4GB)


- Payal Maru
Team Lead - J2EE Application Development
NAVSYA Technologies Pvt. Ltd.
www.navsya.com