title: MySQL - varchar/varchar2 size for user comments
body: <p>I was wondering how can I do the following.</p>
  
  <p>Let's assume a user makes a comment in the provided comment box for an article let's say.
  I want to store the user comment into MySQL DB using a varchar(size) type.
  If I create the table with the <code>varchar(100)</code> and the user comment is longer than 100 chars, how can I adapt to these situations? </p>
  
  <p>Because I would like to not limit its comment size (considering that is decent size).
  Would the solution be based on calculating the length of the comment prior to its insertion...? 
  Assume PHP script is used to process the comment. </p>
  
  <p>thank you   </p>