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 someone has experienced this problem and could > suggest a fix. I'm using MySQL 4.0. > > Your advice will be greatly appereciated. > > Thanks, > > Andrew Pasetti > > *****SQL QUERY RESULTS BELOW********* > > mysql> create table TmpPhoneNumbers > -> ( > -> token char(12) not null, > -> number int(12) primary key > -> ); > Query OK, 0 rows affected (0.05 sec) > > mysql> insert into TmpPhoneNumbers (token,number) > values ('dabw6pz6zkbc',7819359281); > Query OK, 1 row affected (0.05 sec) > > mysql> select * from TmpPhoneNumbers; > +--------------+------------+ >> token | number | +--------------+------------+ >> dabw6pz6zkbc | 2147483647 | > +--------------+------------+ > 1 row in set (1.06 sec) > > __________________________________ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/
In the reference 6.2 Column Types, we have the definition of an int - "The signed range is -2147483648 to 2147483647" That would be (2 * 1024 * 1024 *1024) - 1 Phone numbers might be better stored as Text unless you're going to do arithmetic on them? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
