When I moved to Mandrake 6.1 I installed the MySQL RPM.
I copied over the database files from the old machine, and
everything seemed to be working fine. Now, though,
when I try to insert a number into a BIGINT column,
whether in an old table or a newly created one,
the max value it will except is 2811145986721.
No, wait. actually, what I see in KMySQL and MySQL client is 2811038951321.
The former number is what I got trying to copy+paste into KMail.
This is plain wierd.
Also, if I choose the zero fill option, it will fill the entire
field to the max size I set in the column setup (zero fill).
I've only noticed these problems now. Everything else looked
o.k., and my web applications were behaving. This is the first time I've tried
to change or add data.
Any ideas of what is going on? I've tried int, bigint, real, and float, both
signed and unsigned. varchar works fine.
Bill Ahern
