-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Am Freitag, 16. August 2002 07:44 schrieb Zabach, Elke:
> To store an IP-address, any convenient length of
> CHAR/VARCHAR-column can be used. Because no special
> IP-address-behaviour exists in the SQL-world, there are no
> restrictions/preferences for storing these values.
Elke, a varchar is a char, this gives efforts to code around for
interpreting it.
Hmmm, An IP Adress IP4 is a 4byte (=32 bit) long integer, an IP6 address
is an 6byte (=48 bit) integer value.
I store such things as number like this:
Adress: 192.168.16.215
First binary conversation:
n=215*2^(0*8)+16*2^(1*8)+168*2^(2*8)+192*2^(2*3)
this number can be easy stored as integer(10) in a table,
alowing special subnets is as easy possible as constaints.
Just my 2 cents.
mfG
J�rgen
- --
J�rgen Sauer - AutomatiX GmbH, +49-4209-4699, [EMAIL PROTECTED] **
** Das Linux Systemhaus - Service - Support - Server - L�sungen **
http://www.automatix.de to Mail me: remove: -not-for-spawm- **
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iEYEARECAAYFAj1cmlAACgkQW7UKI9EqarFFRwCg0yJJsxONmMatFAFaYNJA2wKW
jqMAnixc/NrsgcbTXjdba2k71lcvL+me
=t4e2
-----END PGP SIGNATURE-----
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
