List:General Discussion« Previous MessageNext Message »
From:Tim Johnson Date:June 19 2011 3:13pm
Subject:Re: Optimizing column widths
View as plain text  
* Dan Nelson <dnelson@stripped> [110618 16:33]:
> In the last episode (Jun 18), Tim Johnson said:
> > Is there an optimal 'alignment' for column widths for
> > varchar types?
> > 
> > I.E., divisible by 8 or 10 or by powers of 2?
> 
> No.  Varchar fields are stored using only as many bytes as are in that
> particular entry.  The size in the column definition is simply the maximum
> allowed size.
> 
> http://dev.mysql.com/doc/refman/5.5/en/char.html
 Thanks Dan.
 :) Just checking.

-- 
Tim 
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
Thread
Optimizing column widthsTim Johnson19 Jun
  • Re: Optimizing column widthsDan Nelson19 Jun
    • Re: Optimizing column widthsTim Johnson19 Jun