[cobalt-users] Decimal values show up as garbage

[Administrator <cobalt@xxxxxxxxxxxx>]

Hi,

I installed the following mysql, php3 and dbi-perl rpm files in the
following order from ftp://ftp.cobaltnet.com/pub/experimental/

MySQL-3.22.21-2C1.mips.rpm
MySQL-client-3.22.21-2C1.mips.rpm
MySQL-devel-3.22.21-2C1.mips.rpm
mod_php3-3.0.7-1C2.mips.rpm
mod_php3-doc-3.0.7-1C2.mips.rpm
DBI-perl-bin-0.93-rh50.1.mipsel.rpm
data-showtable-3.3-2.mips.rpm
DBI-monitor-3.21.32a-rh50.1.mipsel.rpm
Mysql-DBI-perl-bin-1.1825-rh50.1.mipsel.rpm

on the following system:

Cobalt Raq2
glibc-2.0.7-10


installation went off successfully without any problem and seems like all
the features of mysql are functioning ok.

The problem that we are facing is as follows:

If we create a numeric data type column in a table and add a value such
as 24 (a whole number) it shows up correctly, but if we add a decimal value
to the number it either does not show up or if it does show up it give a
garbage value such as 9756876868668.00 following is an example of what I had
created and what shows up:

# mysql -u username -p
Enter password: password
mysql> use shopping;
mysql> create table test99 (yrs decimal(7,2));
mysql> insert into test99 values (50),(50.00),(10.99);
mysql> select * from test99;

The results are as follows:

+------------+
| yrs           |
+------------+
|      50.00 |
|        0.00 |
| 9999.99 |
+------------+

50 as a whole number has been added ok
50.00 shows up as 0.00
10.99 shows up as 9999.99

Please do let me know where is the problem and how could we resolve it -
incase we need to upgrade glibc to a higher version, how do we go about this
and the rpm files we would require as I have tried this using a rpm :
glibc-2.0.7-29C2.mips.rpm from
ftp://ftp.cobaltnet.com/pub/experimental/ but it did not upgrade and gave
multiple errors "conflicts with file from glibc-2.0.7-10"

Please see if you could help me out

Thanks in advance

Raman Mehta