ricmetal Posted August 11, 2013 Share Posted August 11, 2013 so, they say data type TEXT can have up to 65k bytes. they also say the row limit is 65k. i read something along the lines that TEXT data type only takes up 8 or 9 bytes. is it empty? is the TEXT data type data being stored somewhere else other than in the row? please explain. Link to comment https://forums.phpfreaks.com/topic/281033-text-type-size-row-limit/ Share on other sites More sharing options...
kicken Posted August 11, 2013 Share Posted August 11, 2013 11.6. Data Type Storage Requirements The internal representation of a table has a maximum row size of 65,535 bytes, even if the storage engine is capable of supporting larger rows. This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. Emphasis added As for what is stored in the row buffer (the 9-12 bytes) I do not know exactly, but it likely is some value used to reference where the real value is stored at. Link to comment https://forums.phpfreaks.com/topic/281033-text-type-size-row-limit/#findComment-1444364 Share on other sites More sharing options...
ricmetal Posted August 11, 2013 Author Share Posted August 11, 2013 thanks. thanks. i wasn't sure. besides my lack of reading, the v 4.1 manual doesn't make that emphasis. regards Link to comment https://forums.phpfreaks.com/topic/281033-text-type-size-row-limit/#findComment-1444399 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.