Page 1 of 1

email

Posted: Tue Apr 26, 2005 4:15 pm
by anthony88guy
In my database how big should I make the field for the email? Is 32 char to small? Also should I use varchar?

Posted: Tue Apr 26, 2005 4:24 pm
by timvw
Here are some relevant snippets :

RFC 821, section 4.5.3 :

text line

The maximum total length of a text line including the
<CRLF> is 1000 characters (but not counting the leading
dot duplicated for transparency).


RFC 2821, section 4.5.3 :
text line
The maximum total length of a text line including the <CRLF>
is 1000 characters (not counting the leading dot duplicated
for transparency). This number may be increased by the use
of SMTP Service Extensions.

message content
The maximum total length of a message content (including any
message headers as well as the message body) MUST BE at
least 64K octets. Since the introduction of Internet
standards for multimedia mail [12], message lengths on the
Internet have grown dramatically, and message size
restrictions should be avoided if at all possible. SMTP
server systems that must impose restrictions SHOULD
implement the "SIZE" service extension [18], and SMTP client
systems that will send large messages SHOULD utilize it when
possible.


RFC 2822, section 2.1.1

There are two limits that this standard places on the number of
characters in a line. Each line of characters MUST be no more than
998 characters, and SHOULD be no more than 78 characters, excluding
the CRLF.

Posted: Thu Apr 28, 2005 5:27 am
by rsmarsha
I'd say 32 is too small, i currently use 50, after doing some scans of emails on various sites. Though after reading the first reply i'd stick it at 78. :)