|>>|| No. 16599
>(and not by ensuring it adheres to your incomplete understanding of what an email address is supposed to look like)
Fuck, this. It seems like every other site wants to try and validate email addresses themselves, and inevitably ends up fucking up. What's the right datatype to store an email address in a database? VARCHAR(254). The local part can be up to 64, the domain part can be up to 255, but the whole thing needs to still fit inside 256 after you've put it inside a pair of <>. If you really need to validate the format of an address (and consensus seems to be that this isn't even that good an idea) then at least use something ready made like http://isemail.info.