Hello.
The behaviour of UNSIGNED BIGINT was correct on my Win2k Professional.
Do you use a mysql command line client or other client software?
mysql> create table bu(a bigint unsigned);
Query OK, 0 rows affected (0.20 sec)
mysql> insert into bu values('18446744073709551615');
Query OK
Hi
I am testing against MySQL 4.1 current release on Windows and there seems to
be a fault with unsigned bigint datatypes.
Using a BIGINT UNSIGNED datatype, the maximum value that will be accepted on
insert query is 9223372036854775807 , which is actually the published
maximum for signed Bigints.