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. Also - with any other unsigend integer, an input value which exceeds the maximum will be corrected and be set to the maximum value (eg. input 70000 to a smallint unsigned and you get 65535). However, with BigInt only the resulting value is set to zero. Is this a genuine fault or am misunderstanding something? Tim Hayes
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]