title: NULL vs 0 in integer fields
body: <p>If a SQLite3 database contains a table with integer fields that may contain 'null' but may also contain the integer 0, how can I differentiate between these values? </p>
  
  <p>To my understanding, SQLite represents the integer zero as 'null' and when I run below select statement, the fields that should contain 0 aren't fetched. </p>
  
  <pre><code>SELECT integer_column 
  FROM table_name 
  WHERE integer_column IS NOT NULL; 
  </code></pre>
  
  <p>Also, when I run below query, no rows are returned. (Even though inserts of the value 0 have been done). </p>
  
  <pre><code>SELECT integer_column
  FROM table_name
  WHERE integer_column = 0;
  </code></pre>
  
  <p>What is the best way (common practice) to handle this problem in SQLite? (Keep in mind that the column in my table can contain both 'null' and 0 and that neither value should be considered "corrupt data").</p>