On Tue, Jun 24, 2003 at 03:23:08AM +0100, Robbie Armour wrote:
> $qst = $dbh->prepare("insert into test (t1) values (?)");
> $qst->execute(0.4444);
> $qst->execute('0.3333');
> Binding parameters: insert into test (t1) values (0.4444)
> Binding parameters: insert into test (t1) values (0.3333)
>
> mysql> select * from test;
> +------+
> | t1 |
> +------+
> | 0.44 |
> | 0.33 |
> +------+
>
> My guess from a scan through the DBI man page is that it's some kind of
> typeinfo thing (I'm floundering now)?
My guess is that the DBI and DBD::mysql is working just fine, and
the the mysql command line client is 'helpfully' presenting the
values with just two decimal places. I think you'll find the data is fine.
Tim.
