Updating Numbers
Archived from the Xataface Users forum.
almatesic — Tue Dec 30, 2008 2:35 pm
I have two fields in my table. One being a phone number and the other being a fax number. I set them to be a BigInt field. However I am not able to put either a phone number or fax number higher than 2147483647. Anybody know why?
shannah — Tue Dec 30, 2008 2:51 pm
Better to store phone numbers in a varchar field rather than a numeric field - as phone numbers can store information other than numbers (e.g. country codes/extensions).
Unfortunately Xataface handles bigint fields as php integers, and depending on your system, php can handle integers up to only a certain value (usually integers are 32 bits - so max value of 2^32 which is around 2 billion for signed integers).
This is something that I would like to remedy, but haven’t had a chance to fix yet.
shannah — Tue Dec 30, 2008 3:19 pm
I have posted this issue in the issue tracker, and added a patch there to download: