|Subject||Re: [firebird-php] BIGINT & PHP|
> [Alan McDonald] Where do you actually experience the problems - I mean whatIt was when I used something like
> tasks are you carrying out when you get an error caused by this issue?
$sql = sprintf('INSERT INTO SOMETABLE (BINGINT_FIELD) VALUES (%d)',
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.
web based Firebird and InterBase administration: http://ibwebadmin.sf.net