VARCHAR vs TEXT in MySQL
A long VARCHAR is stored in the same manner as a TEXT/BLOB field in InnoDB (which I assume you’re using for transactionality, referential integrity and crash recovery, right?) – that is, externally to the rest of the table on disk (which may require another disk read to retrieve). From storage prospective BLOB, TEXT as well … Read more