Re: [Hampshire] [OT] BaB Soton Uni register MySQL script

Top Page

Reply to this message
Author: Benjamin M. A'Lee
Date:  
To: Hampshire LUG Discussion List
Subject: Re: [Hampshire] [OT] BaB Soton Uni register MySQL script
On Tue, Jan 13, 2009 at 02:30:42PM +0000, Jacqui Caren wrote:
> Jim Nicholson wrote:
> > This says that an attendee must exist for each mac address, but says
> > nothing about the number of mac addresses per attendee. To add a mac
> > address, you must have an attendee, and you cannot delete an attendee if
> > there are any mac addresses referring to it.
>
> vc(50) for email address is often too short - consider vc(200)
>
> I work with email logs and have hit addresses over 200chrs.


IIRC, the two parts of an email address (i.e. before and after the @)
have a limit of 64 characters each. The local part certainly does; I'm
not so certain about the domain part, but I doubt there are many
hostnames much longer than that.

--
Benjamin M. A'Lee || mail: bma@???
web: http://subvert.org.uk/~bma/ || gpg: 0xBB6D2FA0
"Violence is the last refuge of the incompetent." -- Isaac Asimov