So why is that SQL Server integer definition is:
integer or int
Has a length of 4 bytes, and stores numbers from -2,147,483,648 through 2,147,483,647.
>>Should an integer be -2147483648 To -2147483648 ? Is VFP Integer definition different from other languages ? An integer is a 32 bit value no?
>>
>>
>>>The integer field type can hold values in the range of -2147483647 to 2147483647. You're attempting to insert 2147483648 (2 ^ 31).
>
>Consider that there are 4,294,967,295 possible values (2 ^ 32 - 1). With a signed integer the range is exactly half for the positive and negative values minus one. IOW, doing integer division on 4,294,967,295 yields +/- 2,147,483,647. So where's value 4,294,967,295? It's zero.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only