Comment on How MySQL memory table saved the dayComments−Zr4012yVarchars 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!)−webstartupperOP12y"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...I had no idea about this either....−jcampbell112yMEMORY tables use a fixed-length row-storage format. Variable-length types such as VARCHAR are stored using a fixed length.
Comments
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!)
"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...
I had no idea about this either....