It is a mysql database

create table mytable (field float);

insert into mytable (field) value (1679971) ;

Mysql is not the problem I think, because if I use php I get 1679971 but with perl i get 1679970

It has to be the way perl represents the float value