17 Feb
2005
17 Feb
'05
11:46 p.m.
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