Subject | Re: [firebird-php] BIGINT & PHP |
---|---|
Author | Lutz Brückner |
Post date | 2004-04-17T13:22:12Z |
> [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)',
$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