22 Oct
2012
22 Oct
'12
1:43 p.m.
On 10/22/12 4:11 PM, Juha Heinanen wrote:
lcr_gw table has:
ip_addr varchar(47)
trusted table has:
src_ip varchar(50)
address table has:
ip_addr varchar(48)
why is it that they are not all the same? also, why the common length
is not 8 * 4 + 7 = 39
(http://en.wikipedia.org/wiki/IPv6#Address_format)?
if you take in consideration
the ipv4 tunneling address format, then it
is 45, plus square bracket representation [...] results in 47.
For safety, i would use 48, to allow zero termination -- not sure it is
actually needed, just that we have some custom db backend that might
require it it, like dbtext. Anyhow, varchar(x) is well known db systems
allocate only what is needed.
Cheers,
Daniel
-- juha
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
Kamailio Advanced Training, Miami, USA, Nov 12-14, 2012 - http://asipto.com/u/katu