2 ms·
Probably a result of supporting multiple backends. AFAIR, MySQL requires a length to be passed on VARCHAR.
by tcdent 13y ago
Probably a result of supporting multiple backends. AFAIR, MySQL requires a length to be passed on VARCHAR.
- falcolas 13y agoYes, because varchar is implemented as a fixed-length list of characters. Text fields are implemented as blobs, and as such can grow large enough to have to be stored off-page (with all of the associated performance hits associated with that).