Rounding errors storing numbers in MySQL text fields using DBI

[Robbie Armour]

Hello other DBI Users

I use MySQL text fields as general repositories for code, data etc but find 
that numbers are rounded to two decimal places.  This does not happen with a 
similarly constructed Oracle table - eg

 my $c = $dbh->prepare("insert into test (t1) values (?)");
 $c->execute(0.4444);
 $c->execute(0.5555);
results in 0.44 and 0.56 being stored in the text field.  If field t1 is 
varchar this does not happen.

Has anyone got a fix for this?  I know I can kludge it, but I'd rather code 
it straight!

Thanks, Robbie Armour

_________________________________________________________________
Tired of 56k? Get a FREE BT Broadband connection 
http://www.msn.co.uk/specials/btbroadband