[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Optimizing column widths
From:       Tim Johnson <tim () johnsons-web ! com>
Date:       2011-06-19 15:13:47
Message-ID: 20110619151347.GD1971 () johnsons-web ! com
[Download RAW message or body]

* Dan Nelson <dnelson@allantgroup.com> [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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]