Subject Re: [firebird-php] BIGINT & PHP
Author Lutz Brückner
> [Alan McDonald] Where do you actually experience the problems - I mean what
> tasks are you carrying out when you get an error caused by this issue?

It was when I used something like

$sql = sprintf('INSERT INTO SOMETABLE (BINGINT_FIELD) VALUES (%d)',
$bigint_value);

The %d represents an integer in the sprintf-syntax and so 2147483647 was
inserted if $bigint_value was a bigger number. Replacing %d with %s
solved the problem.

There is no problem with fetching BIGINT values from a table because the
ibase_fetch_xxx() functions returning them as strings.

Lutz
--
web based Firebird and InterBase administration: http://ibwebadmin.sf.net