Optimizing column widths

Is there an optimal 'alignment' for column widths for
varchar types?

I.E., divisible by 8 or 10 or by powers of 2?

URLs to documentation would be more than sufficient.

Version 5+, linux platforms.

thanks
--
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=gcdmg-mysql-2@m.gmane.org

Re: Optimizing column widths

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@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Optimizing column widths

* Dan Nelson [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=gcdmg-mysql-2@m.gmane.org