List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 19 2011 12:22am
Subject:Re: Optimizing column widths
View as plain text  
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

-- 
	Dan Nelson
	dnelson@stripped
Thread
Optimizing column widthsTim Johnson19 Jun
  • Re: Optimizing column widthsDan Nelson19 Jun
    • Re: Optimizing column widthsTim Johnson19 Jun