Re: unsigned int

Marek Simon wrote:
I have mysql database for internal computer evidence and I store IP as unsigned numeric value. It is very good for computing network ranges and so on. But PHP do not support unsigned integer. So when I store values to doatabase, I must convert it to string with sprintf. When reading it, I get a string value with 10-digit number, bigger than maxint. I need to convert it to signed int and work with it as a number (for making binary arithmetics). I have discovered no way how to do it. Intval() or (int) type conversion returns maxint. Converting it in mysql is anoying too, because mysql cant do signed 32-bit int type conversion, only 64 bit.
Marek

Have you considered using the php/nmysql build-in functions (available as of PHP 5.0):

PHP:
inet_ntop() http://nl2.php.net/manual/en/function.inet-ntop.php
inet_pton() http://nl2.php.net/manual/en/function.inet-pton.php

MySQL:
INET_ATON() and INET_NTOA() http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html

Jonathan
.