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. Quote Link to comment Share on other sites More sharing options...
Solution kicken Posted August 11, 2013 Solution 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.