title: MySQL double type comparation fails
body: <p>I am developing a chat module with JavaScript and php+mysql and I am storing the chat data into a simple table with: <code>id, member1, member2, message, timestamp</code>.
  The <code>timestamp</code> column is <strong>double(14,4)</strong>, where I store the timestamp on microseconds level, ex:
  1330522898.3137;</p>
  
  <p>My problem is: 
  When I am comparing this timestamp with another one, like</p>
  
  <pre><code>   SELECT * FROM chat_rows WHERE timestamp &gt;= 1330535168.9548
  </code></pre>
  
  <p>Only on particular numbers, like this one above, I get 0 rows using operator <code>&gt;=</code> although I have a row with exact same value; This is proved by the almost same query differentiated by operator <code>=</code> :</p>
  
  <pre><code>   SELECT * FROM chat_rows WHERE timestamp = 1330535168.9548
  </code></pre>
  
  <p>which returns one row;</p>
  
  <p>The workaround for this is to replace the double(14,4) type with varchar but is slower than double;</p>
  
  <p>Also fails only on this server ( my development one ):
  Apache/2.2.20 (Ubuntu)
  MySQL client version: 5.1.58</p>
  
  <p>On my local it seems that works; - which is windows
  Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/0.9.8o
  Versiunea clientului MySQL: mysqlnd 5.0.8-dev - 20102224 - $Revision: 318113 $</p>
  
  <p>Any thoughts ? </p>
  
  <p>Thanks in advance! </p>