RE: [PHP] Trying to insert a large number from php to mysql

Thanks What I'm doing now to work around is using number_format() and str_replace() to remove the ",". This give me the string and mysql uses it correctly. -----Original Message----- From: Jon Anderson [mailto:jon@gamingsolutions.ca] Sent: Wednesday, December 20, 2006 5:59 PM To: WeberSites LTD Cc: php-general@lists.php.net Subject: Re: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php