List:General Discussion« Previous MessageNext Message »
From:Waynn Lue Date:November 10 2009 11:37pm
Subject:storage difference in VARCHAR(size)?
View as plain text  
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?

Thanks for any insight,
Waynn

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