title: SQLite does not check Data Types
body: <p>Dear Stack Overflow Community,</p>
  
  <p>I have a little problem here with starting my first attempt to Database-Design.</p>
  
  <p>I try to make some Kind of a tabular and try to check out the Basic functions; writing with Python3 and SQLite3.</p>
  
  <p>My question is quite simple, I have a few lines:</p>
  
  <pre><code>cur.execute('CREATE TABLE IF NOT EXISTS test(a INTEGER, argument DATE)')
  </code></pre>
  
  <p>Now I can just write:</p>
  
  <pre><code>cur.execute('insert into test (a, argument) values (?,?)', "bla", "blabla")
  </code></pre>
  
  <p>Without getting an error message; shouldn't this command be automatically forbidden by SQL when you define the allowed datatypes in the <code>CREATE TABLE</code> statement?</p>
  
  <p>Full code is here: <a href="http://codepad.org/kf4gZB7m" rel="nofollow noreferrer">http://codepad.org/kf4gZB7m</a></p>