Taking this in a direction that might be more helpful to feders, let me ask, what is the best length for the email field?
I don't think 50 is big enough. As I understand, all valid emails fit in 256 bytes. Anyone have a definitive answer on this one? Is it in characters or bytes?
Let me also ask what character encoding should he use? Are there people using unicode email addresses?
I realize this may be over designing a bit and a bit academic. Most people probably use a least common denominator email, rather than exotic but valid emails. However, I've run into bug reports at various times about people with valid email addresses that we're rejected due to one or another restriction that wasn't technically necessary.
What's the best definition of an email field in mysql? Lets get it on the record.