If I enter the number 5094791727 into a ten digit int in MySQL using either MySQL or PHP and then go back and recall the number, it will have stored 2147483647.

Actually if I enter 509479172? (with the ? being a number 0-9) it will store 2147483647.

But ANY other number I enter it will store and recall correctly.

WHAT is with this and how do I store the number 5094791727 and why is my problem so specific to the number 5094791727?

Thanks.