17 Feb
2005
17 Feb
'05
4: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