title: MySql IEEE floating point NaN, PositiveInfinity, NegativeInfinity
body: <p>I have looked at many questions regarding this problem, but I have not found a solution. Hopefully this is not a duplicate question.</p>
  
  <h1>Problem</h1>
  
  <p>If I do any of:</p>
  
  <pre><code>INSERT INTO `Numbers`(`Number`) VALUES ('NaN')
  INSERT INTO `Numbers`(`Number`) VALUES ('Inf')
  INSERT INTO `Numbers`(`Number`) VALUES ('+Inf')
  </code></pre>
  
  <p>I get 0.0 inserted in the table. Sometimes I get:</p>
  
  <pre><code>Error Code: 1265. Data truncated for column 'Number'
  </code></pre>
  
  <p>I have also tried different casing and spelling, all with the same effect.</p>
  
  <p>I have even tried:</p>
  
  <pre><code>INSERT INTO `Numbers`(`Number`) VALUES ('1111111111111000000000000000000000000000000000000000000000000000')
  </code></pre>
  
  <p>How do I insert a NaN floating point number into a MySql table?</p>
  
  <p>If it really isn't possible then what is the reasoning? (Maybe I am using the incorrect version of MySql?)</p>
  
  <h1>Using NULL as NaN</h1>
  
  <p>The tables where I am actually using this I don't want to allow NULL values in those columns. So I don't like the idea of replacing NaN with NULL somewhere in the ORM layer</p>