Total members 11892 |It is currently Fri Oct 18, 2024 2:18 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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.



_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  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 Pointers in C++     -  
 Types of Registers     -  
 pointers to derived types     -  
 java data types     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com