I’ve written lots of app’s which store email addresses, and usually go for a nvarchar(100) to store them, but thought I would find out once and for all, what the actual maximum size was- just out of curiousity.
Having googled around, I came across a couple of lengthy posts on the matter (here and here), quoting figures from various standard (which seemed to point at 320 character), then corrections to those standards by members of ICANN based on the SMTP spec and so on and so forth…
After much trawling, it seems the official answer is : 254 characters (256 including the standard <> brackets around the address)
Related posts:
#1 by Eugenia on December 1, 2009 - 10:47
Cool…254 characters. Glad I learned something new today.
#2 by shawson on December 1, 2009 - 10:49
every day’s a school day!