"what's the difference between varchar(255) and tinytext string types in mysql?" Code Answer

4

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.

By chris finne on April 18 2022

Answers related to “what's the difference between varchar(255) and tinytext string types in mysql?”

Only authorized users can answer the Search term. Please sign in first, or register a free account.