Re: Trying to insert a large number from php to mysql

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