From: Dan Nelson Date: July 13 2003 7:41pm Subject: Re: Storage efficiency of VARCHARs List-Archive: http://lists.mysql.com/mysql/145059 Message-Id: <20030713194138.GG23909@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Jul 13), Dan Anderson said: > I am curious about the internal representation of VARCHARS. I cannot > find any documentation on it in the mySQL manual. Will a VARCHAR(10) > take up less space then a VARCHAR(80), even though they are variable? It's documented at least twice in the manual. See the section "The CHAR and VARCHAR Types": http://www.mysql.com/doc/en/CHAR.html , and also "Column Type Storage Requirements": http://www.mysql.com/doc/en/Storage_requirements.html -- Dan Nelson dnelson@stripped