Hi,
I store numbers in FLOAT(8) column in mySQL. Most of them are
very small (<1e-5), and when I do 'SELECT' (through perl DBI/DBD) most of
them show up as 0.000. I have the following questions:
1. I couldn't find a format function for numbers that I can use to get my
number in 'XXX.XXe+XX' format (ala sprintf("%g") in C/perl). Do I have
to resort to User-defined function?
2. More importantly, should DBD::mysql perl module returns the "double"
representation of the results rather than just 0.000?
I am sure the number in the database is not zero because select
X*1e+9 works as expected. I am using mySQL 3.22.14b-gamma for sgi-irix6.5
I built from source distribution. The Perl interpreter used is 5.005_02,
DBI version 1.06 and DBD::mysql 2.0214.
Thanks,
Atipat
----
Atipat Rojnuckarin
[EMAIL PROTECTED]
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
