-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jochem van Dieten wrote:
> rmck said: > >>I have "ip_address" and "ports" that I want to use in my table. I >>was just going to make each one a varchar. But was wondering if >>anyone has a better suggestion? > > > PostgreSQL ;-) > > It has a native datatype for storing IP addresses. That means that > things like sorting and subnet inclusion tests come included with the > database. But switching databases is not something to be undertaken > lightly. Or take a look at the INET_ATON() and INET_NTOA() functions in the MySQL manual at http://www.mysql.com/doc/en/Miscellaneous_functions.html that allow you to convert the IP address to an integer.... Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAGS2MtvXNTca6JD8RAgkdAKC5rcoyIMJFOaklzT8TaLONQLPsqACfUImB p//aTmYu/i84jWOJ0PqX8Mk= =OODk -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]