Jan 30, 2010

Int(10) is not sufficient size for a Facebook User Id

The examples I have seen use INT(10) for SQL databases, but just tonight I was experimenting with two new users and was seeing this peculiarity: all the user_id values saved to the database were reported as 4294967295. This is the maximum INT(10) I believe, so if you want to use your Facebook app with new users, you need to amend your data to BIGINT(20). Then it works.