I installed the MySQL server 3.22.27 RPM. The problems are no more.
I still don't know what the problems were about, but after spending all
last night looking for answers I would suggest others update.
Bill Ahern
MIS, JINSA
On Fri, 15 Oct 1999, you wrote:
> 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
