Dear Attila,
I am not a mathematician but I guess you used INT and the data seem to
be out of range.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Attila Soki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 12:44 AM
Subject: double column type why...
> hi,
>
> please help me... i can't understand why are my doubles incorrect.
>
> create table test (dnum double(20,5));
> insert into test values(8999999999999998);
> insert into test values(8999999999999998.0001);
> insert into test values(899999999999998.0001);
> insert into test values(89999999999998.0001);
> insert into test values(1.0001);
> select * from test;
> +------------------------+
> | dnum |
> +------------------------+
> | 8999999999999998.00000 |
> | 8999999999999997.00000 |<<<<<<<<<<<<<<< HERE
> | 899999999999998.00000 |<<<<<<<<<<<<<<< HERE
> | 89999999999998.00000 |<<<<<<<<<<<<<<< HERE
> | 1.00010 |
> +------------------------+
>
> intel PII-450 / debian-2.2.19 / mysql 3.23.32
> intel PIII-833 / debian-2.2.19 / mysql 3.23.37
>
> thanx
>
> Attila Soki
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
