title: How to return NULL instead of 0 from MySQL TinyInt(1)
body: <p>I've moved a site from ColdFusion 10 to ColdFusion 2016, and I've noticed when querying a MySql database, <code>tinyint(1)</code> fields that are <code>null</code> would previously come back to ColdFusion as empty values but now come back as <code>0</code>.</p>
  
  <p>Anyone know if this is a MySql or CF2016 thing, and how I can get it to return empty values again?</p>
  
  <p>I've googled, but all results seems to be about turning <code>0</code> into <code>null</code>. I need it the other way around! <a href="https://coldfusion.adobe.com/2018/07/null-support-in-coldfusion-2018/" rel="nofollow noreferrer">CF2018 seems to have changed their null support</a>, but I can't find anything relating to C2016.</p>