title: MySQL running in Strict Mode and giving me problems. How to fix this?
body: <p>I have a CSV I download from the State of Florida so I'm not in control over what's in the file.  There are some fields (such as price) that are sometimes null.  In my table where I'm importing these values, I marked sold_price as BIGINT, Unsigned, Allow Null and default of Null.  However, when I attempt to insert a NULL value (empty cell in the CSV), I get the error:</p>
  
  <pre><code>[PDOException]
  SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'sold_price' at row 1
  </code></pre>
  
  <p>I followed the advice <a href="https://stackoverflow.com/questions/8874647/general-error-1366-incorrect-integer-value-with-doctrine-2-1-and-zend-form-upda/8882396#8882396">in this answer someone posted</a> and that fixes the problem.  However, whenever MySQL is restarted, I get the error again and have to redo that query.</p>
  
  <p>Also, I don't think that's the appropriate way to fix the problem, is it?  What should I be doing in cases where a field such as sold_price is null and I'm trying to insert it into a table?</p>
  
  <p>I'm running MySQL version 5.6.13.</p>