3 ms·
> Varchars take up the space for all the chars defined. This only applies to memory tables. For non-memory tables, the size of varchar columns depends on the a
by Zr40 13y ago
> Varchars take up the space for all the chars defined.
This only applies to memory tables. For non-memory tables, the size of varchar columns depends on the actual string size.
(edited. Thanks for correcting!)
- jcampbell1 13y ago> MEMORY tables use a fixed-length row-storage format. Variable-length types such as VARCHAR are stored using a fixed length.
- webstartupper 13y ago"MEMORY tables use a fixed-length row-storage format. Variable-length types such as VARCHAR are stored using a fixed length." From - http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine... I had no idea about this either....