title: varchar(255) vs tinytext/tinyblob and varchar(65535) vs blob/text
body: <p>By definition:</p>
  
  <blockquote>
    <p>VARCHAR: The range of Length is 1 to 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given.    x+1 bytes<br>
    TINYBLOB, TINYTEXT: A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters    x+1 bytes</p>
  </blockquote>
  
  <p>So based on this, I creaate the following table:</p>
  
  <pre><code>CREATE TABLE `user` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255),
    `lastname` tinytext,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>Or is it better to create a varchar or tinytext and <strong>why</strong>?</p>
  
  <p>Is it the same for:</p>
  
  <blockquote>
    <p>VARCHAR:   The range of Length is > 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given. x+2 bytes<br>
    BLOB, TEXT A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters  x+2 bytes</p>
  </blockquote>