MYSQL TEXT field types lengths

Wed Jan 09, 2013 12:07 am

In MYSQL there are four type of TEXT fields which are :
TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT ,
The lengths of these types are :

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

The maximum size of single row in MYSQL is 65,535 bytes, all records must follow the same limit, but fields of type TEXT are stored outside the table storage and associated to the table. Type TEXT is the most frequently used type.