If an INT has a fixed range, then what is the point of giving it scale? As
in, int(12).
In Oracle, a NUMBER(12) indicates how many digits you could have (in this
case, 999 would be the max value).
Would an int(2) allow -99 to 99, or -2147483648 to 2147483647?
That's because in
In the last episode (Dec 14), A Pasetti said:
When attempting to insert an integer into an integer column, a
different value is being inserted for the given row. Check out the
sql below to see what I mean. The integer 7819359281 is somehow
changed to 2147483647 when it's inserted.
Perhaps
At 18:42 -0800 12/14/03, A Pasetti wrote:
When attempting to insert an integer into an integer
column, a different value is being inserted for the
given row. Check out the sql below to see what I mean.
The integer 7819359281 is somehow changed to
2147483647 when it's inserted.
Have you considered
A Pasetti mailto:[EMAIL PROTECTED] wrote:
When attempting to insert an integer into an integer
column, a different value is being inserted for the
given row. Check out the sql below to see what I mean.
The integer 7819359281 is somehow changed to
2147483647 when it's inserted.
Perhaps
an error if someone tries to create an int(xyz)
column that exceeds the size of an int?
David.
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: A Pasetti [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 6:48 PM
Subject: Re: integer not being inserted
David Griffiths wrote:
If an INT has a fixed range, then what is the point of giving it scale? As
in, int(12).
In Oracle, a NUMBER(12) indicates how many digits you could have (in this
case, 999 would be the max value).
Would an int(2) allow -99 to 99, or -2147483648 to 2147483647?
Maybe
the size of an int?
David.
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: A Pasetti [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 6:48 PM
Subject: Re: integer not being inserted correctly
In the last episode (Dec 14), A Pasetti said:
When