note 43468 deleted from function.mysql-query by mazzanet
| From: | mazzanet@php.net | Date: | Sun, 02 Oct 2005 13:33:06 +0000 |
| Subject: | note 43468 deleted from function.mysql-query by mazzanet | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-96181@lists.php.net to get a copy of this message | ||
Note Submitter: diag at chREMOVEeerful dot com
----
On mysql 4.0.0-alpha-NT, using float as column type in my case as part of a two-field primary key,
will after inserting/updating the 0.66 not find the record with key 0.66 when searched for by
key=0.66 (but with: key>0.65 AND key<0.67).
Solution: use DECIMAL(3,2) (or bigger).