Updating Numbers

[almatesic]

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]

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]

I have posted this issue in the issue tracker, and added a patch there to download:
http://bugs.weblite.ca/view.php?id=455