17 Feb
2005
17 Feb
'05
11:49 p.m.
Juha,
Can the IP be stored as a character field rather than as an int?
Paul
On Thu, 17 Feb 2005 23:46:08 +0200, Juha Heinanen <jh(a)lohi.tutpro.com> wrote:
Richard writes:
When you create the table field, you can use
attribute "unsigned".
sure and that is what gw table is using (ser_mysql.sh):
#
# Table structure for table 'gw'
#
CREATE TABLE gw (
gw_name VARCHAR(128) NOT NULL,
ip_addr INT UNSIGNED NOT NULL,
port SMALLINT UNSIGNED,
grp_id INT UNSIGNED NOT NULL,
PRIMARY KEY (gw_name),
KEY (grp_id)
) $TABLE_TYPE;
the problem is that
VAL_INT(ROW_VALUES(row)
for ip_addr field produces wrong value if the first bit of the value in
db is 1.
-- juha
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers