email

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
anthony88guy
Forum Contributor
Posts: 246
Joined: Thu Jan 20, 2005 8:22 pm

email

Post 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?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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.
rsmarsha
Forum Contributor
Posts: 242
Joined: Tue Feb 08, 2005 4:06 am
Location: Leeds, England

Post 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. :)
Post Reply