On Jun 21, 2011 9:29 AM, "Ryan Chan" <ryanchan404(a)gmail.com> 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