[Serusers] LCR Module Question

[Java Rockx]

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 at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>