title: What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
body: <p>When creating a table in SQLite3, I get confused when confronted with all the possible datatypes which imply similar contents, so could anyone tell me the difference between the following data-types?</p>
  
  <pre><code>INT, INTEGER, SMALLINT, TINYINT
  
  DEC, DECIMAL
  
  LONGCHAR, LONGVARCHAR
  
  DATETIME, SMALLDATETIME
  </code></pre>
  
  <p>Is there some documentation somewhere which lists the min./max. capacities of the various data-types?  For example, I guess <code>smallint</code> holds a larger maximum value than <code>tinyint</code>, but a smaller value than integer, but I have no idea of what these capacities are.</p>