WeberSites LTD wrote:
I'm trying to insert the number 1970324970930197 into a mysql BigInt(20)
field.
If I do a direct insert from mysql command prompt and select the record I
get
back the same number.
If I do this from PHP I get back 1970324970930000. Notice that the 197 at
the
end is not 000.
AFAIK, PHP uses 32-bit (signed) integers, so you're stuck to values no
bigger than around 2 billion. Anything larger, and you have to store it
as a string: use a "BigInt" class, or GMP functions to do calculations.
I believe MySQL will do the right thing if you insert a string "integer"
into an integer field.
jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
