Row size limits in Mysql w.r.t to TEXT and BLOB columns
0
votes
2
answers
303
views
There is a well-known limitation in Mysql for row size which 65,535 bytes.
While going through the docs ,
I have found that
> BLOB and TEXT columns only contribute 9 to 12 bytes toward the row
> size limit because their contents are stored separately from the rest
> of the row.
I did go through the MySQL documentation but unable to understand when a TEXT column will contribute 9 bytes and when it will contribute 12 bytes. Can anyone explain how to interpret the statement?
Asked by Dinesh Kumar
(664 rep)
May 14, 2020, 12:46 PM
Last activity: May 1, 2025, 01:07 PM
Last activity: May 1, 2025, 01:07 PM