Select Code to Download

mysql> SELECT '18015376320243458' = 18015376320243458;
        -> 1
mysql> SELECT '18015376320243459' = 18015376320243459;
        -> 0

$sth->bind_param(1, $n, { TYPE => SQL_INTEGER });

$sth->bind_param(1, $n);

perl, v5.8.8 built for x86_64-linux-thread-multi
DBI is up to date (1.603).
DBD::mysql is up to date (4.006).
MySQL Server version: 5.0.33 Source distribution
Linux 2.6.9-42.ELsmp x86_64 x86_64 x86_64 GNU/Linux

create table foo(i decimal(23,0) primary key);

$sth->bind_param(1, $n);
$sth->bind_param(1, $n, { TYPE => SQL_INTEGER });

create table foo(i bigint primary key);

use strict;
use warnings;
...

__END__

$ prove bind_param.pl
bind_param.......# DBD::mysql: 4.006
...
Result: FAIL
Failed 1/1 test programs. 13/3002 subtests failed.
$

6700000000000000500 - 6700000000000000512
6700000000000001536 - 6700000000000002499
...
6700000000000006500 - 6700000000000007679
6700000000000008500 - 6700000000000008704
6700000000000009400 - 6700000000000009727

mysql> select version();
+-----------+
...

mysql> select i from foo where i='6700000000000000502';
Empty set (0.00 sec)