RE: integer not being inserted correctly

2003-12-15 Thread Mike Brando
> > 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 bec

Re: integer not being inserted correctly

2003-12-14 Thread Paul DuBois
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 inserte

Re: integer not being inserted correctly

2003-12-14 Thread Daniel Kasak
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? Mayb

Re: integer not being inserted correctly

2003-12-14 Thread David Griffiths
ould throw 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

RE: integer not being inserted correctly

2003-12-14 Thread Sweet, Charles E
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. > > Perh

Re: integer not being inserted correctly

2003-12-14 Thread Paul DuBois
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 w

Re: integer not being inserted correctly

2003-12-14 Thread Dan Nelson
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. > > Perh

integer not being inserted correctly

2003-12-14 Thread A Pasetti
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 someone has experienced this problem and could suggest