Re: MySQL 4.1.7: cast(1-2, unsigned) != cast('18446744073709551615' as unsigned)

ng the latter. Cheers, Robin Gleb Paharenko wrote: Hello. I've submitted a bug http://bugs.mysql.com/7036. Robin Bryce <[EMAIL PROTECTED]> wrote: Hi, I'm having trouble converting to and from strings that represent unsigned BIGINT's. My server is MySQL 4.1.7-standard and the fol

MySQL 4.1.7: cast(1-2, unsigned) != cast('18446744073709551615' as unsigned)

t('18446744073709551615' as unsigned); yields '9223372036854775807' better known as '0x7fff'. Can anyone tell me what is happening here ? Thanks, Robin Bryce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]