It looks to me like 'a' is '127-30-127-1'
Notice the dashes.
I don't believe you are splitting the IP address into 4 separate numbers.
Chris Knipe wrote:
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was pointed out to me that I could use four smallint columns instead of a
varchar to store these numbers, and just implement a UNIQUE index across all
four
Chris Knipe wrote :
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was pointed out to me that I could use four smallint columns instead of a
varchar to store these numbers, and just implement a
Hi Chris,
On Sat, Jun 08, 2002 at 11:44:43AM +0200, Chris Knipe wrote:
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was pointed out to me that I could use four smallint columns instead of a
varchar to store