Each of them allows to store strings with a maximum length of 255 characters. Storage requirements are also the same. When should I prefer one over another?
推荐答案
您不能为 TINYTEXT 分配 DEFAULT 值，也不能在后者上创建无前缀索引.
You cannot assign a DEFAULT value to a TINYTEXT and you cannot create an unprefixed index on the latter.
Internally, additional objects are allocated in memory to handle TEXT (incl. TINYTEXT) columns which can cause memory fragmentation on the large recordsets.
请注意，这仅涉及记录集中列的内部表示，而不涉及它们在磁盘上的存储方式.
Note that this only concerns the column's internal representation in the recordsets, not how they are stored on the disk.
