Problem with floating point data types in MySQL

["Alejandro Lee Ibarra" <alee@megared.net.mx>]

I'm new in this forum but i'd appreciate if someone could help me.
I installed MySQL's Debian packages on my ARM-based system and
when i insert any value to a floating point field, the server writes
a
wrong number.

For example:
*****************************
//Suppose the following table:
mysql> create table prueba(
    -> campo                           numeric(10,2)
    -> );
Query OK, 0 rows affected (0.11 sec)

mysql> describe prueba;
+-------+---------------+------+-----+---------+-------+
| Field | Type          | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| campo | decimal(10,2) | YES  |     | NULL    |       |
+-------+---------------+------+-----+---------+-------+
1 row in set (0.05 sec)

mysql> insert into prueba values (15230.23);
Query OK, 1 row affected (0.05 sec)

mysql> select * from prueba;
+------------+
| campo      |
+------------+
| 9999999.99 |
+------------+
1 row in set (0.04 sec)

mysql>
*********************

what's going wrong? this doesn't happen in the x86 package.

Thanks in advance,
- Alejandro

--
======================================
\       M.Sc.Alejandro Lee Ibarra    /
 \      Quality assurance           /
  >     DDTec Mexico               <
 /      http://www.didtec.com.mx    \
/       01-52-333-825-6563           \
======================================


-- 
To UNSUBSCRIBE, email to debian-arm-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org