From: Michael Dykman
Date: November 11 2009 3:44am
Subject: Re: storage difference in VARCHAR(size)?
List-Archive: http://lists.mysql.com/mysql/219325
Message-Id: <814b9a820911101944y45197e72iee559f81ea3d8b0b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You have stumbled across the secret.  No, there is no difference at
all as the calculations suggested here confirm.

http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html

On Tue, Nov 10, 2009 at 6:37 PM, Waynn Lue <waynnlue@stripped> wrote:
> Hey all,
>
> I was building a table for storing email addresses today and ran into an
> issue that I couldn't find an answer for using Google. =A0If I declare th=
e
> column as a VARCHAR (this is an InnoDB table), does it matter what size I
> declare it as if it's between 1 and 255? =A0I know there's an extra byte =
of
> storage once it goes above 255 because of the length, but is there a stor=
age
> difference between VARCHAR(100) and VARCHAR(255)? =A0Obviously there's a
> functional difference in what gets cut off when I try to store into that
> table, but is that the only difference?
>
> Thanks for any insight,
> Waynn
>



--=20
 - michael dykman
 - mdykman@stripped

"May you live every day of your life."
    Jonathan Swift

Larry's First Law of Language Redesign: Everyone wants the colon.