Switch to full style
Tutorials, source code, tips and tricks related to mysql
Post a reply

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.



Post a reply
  Related Posts  to : MYSQL TEXT field types lengths
 How To Store Date Dynamically as a field in mysql using JSP     -  
 Get Text Field value by php     -  
 Please help me in the form field     -  
 Get field length     -  
 Able to Copy Text from Uneditable Text Boxes(JTextfields)     -  
 List Database, Table, and Field in php     -  
 Types of Registers     -  
 Types of Pointers in C++     -  
 java data types     -  
 temperature transformer between different types     -