List:General Discussion« Previous MessageNext Message »
From:Waynn Lue Date:November 11 2009 7:24pm
Subject:Re: storage difference in VARCHAR(size)?
View as plain text  
Oh, I wasn't seeing a difference, I just wanted to make sure I understood
how the two choices affected our system.

Thanks so much for all the answers!

On Wed, Nov 11, 2009 at 11:12 AM, Johan De Meersman <vegivamp@stripped>wrote:

> Your mail suggests that you *are* seeing a difference, though. What
> are you seeing?
>
> On 11/11/09, Martijn Tonies <m.tonies@stripped> wrote:
> >>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
> >
> > Note: as you can see in the above, CHAR data DOES take up room for it's
> > full size, stupidly enough.
> >
> > 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. If I declare the
> >> 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? I know there's an extra byte of
> >> storage once it goes above 255 because of the length, but is there a
> >> storage
> >> difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
> >> functional difference in what gets cut off when I try to store into that
> >> table, but is that the only difference?
> >
> > With regards,
> >
> > Martijn Tonies
> > Upscene Productions
> > http://www.upscene.com
> >
> > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> > Anywhere, MySQL, InterBase, NexusDB and Firebird!
> >
> > Database questions? Check the forum:
> > http://www.databasedevelopmentforum.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
storage difference in VARCHAR(size)?Waynn Lue11 Nov
  • Re: storage difference in VARCHAR(size)?Michael Dykman11 Nov
  • Re: storage difference in VARCHAR(size)?Martijn Tonies11 Nov
    • Re: storage difference in VARCHAR(size)?Johan De Meersman11 Nov
      • Re: storage difference in VARCHAR(size)?Waynn Lue11 Nov
  • Re: storage difference in VARCHAR(size)?Martijn Tonies11 Nov
    • Re: storage difference in VARCHAR(size)?Johan De Meersman11 Nov