Nic Jansma personal blog

MySQL Text vs. Varchar Performance

Starting with MySQL 5.0.3, the maximum field length for VARCHAR fields was increased from 255 characters to 65,535 characters. This is good news, as VARCHAR fields, as opposed to TEXT fields, are stored in-row for the MyISAM storage engine (InnoDB has different characteristics). TEXT and BLOB fields are not stored…
Points
112
HN comments
20
Submissions
1
Cited by
0 commenters

Databases & DataSoftware Engineering2011

On Hacker News

SubmittedTitle on HNPointsComments
May 10, 2011MySQL Text vs. Varchar Performance by mrdraper11220

Related posts from the same era