Helmut Ebelt wrote:
>
> I have some kind of floats(8,2) in my table and want to make an query ...
>
> Select * from tablename where floatthing = '21999.00';
>
> 0 rows !
>
> Select * from tablename where floatthing = 21999.00;
>
> 0 rows !!
>
> but there ARE result !! can anybody help me !! please
>
> thx in advance !
>
> HElmut Ebelt
> :-===========<http://www.webmaid.de>===========-:
> :-Helmut Ebelt - Ahornstr. 25 - 12163 Berlin-:
> :-===========<http://www.webmaid.de>===========-:
>
> ---------------------------------------------------------------------
Floats can not be reliably tested for equality. They are stored in a
binary
form that cannot precisely represent most numbers.
If you need to test for equality, check out the DECIMAL type.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php