On Jun 21, 2011 9:29 AM, "Ryan Chan" <[email protected]> wrote: > > According to this: > http://www.mediawiki.org/wiki/Manual:User_newtalk_table, IP was stored > using varchar(40) . > > But seems 45 should be the safe instead of 39? > > http://stackoverflow.com/questions/4982701/best-way-to-store-ip-in-database
The 45-char version is for the dotted-quad variant of an ipv4 mixed address. I think we're normalizing to the canonical grouped hex form with elided zeroes so that format wouldn't get stored. -- brion _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
