Hello
RFC2822 section 2.1.1 "Line Length Limits" specifies a maximum of 998 characters per line (excluding trailing CRLF).
So changing the column to VARCHAR(998) seems more appropriate. Just my 2 cents. Martin On Tue, 2 May 2006 [EMAIL PROTECTED] wrote:
The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=338 ====================================================================== Reported By: ryo Assigned To: ====================================================================== Project: DBMail Issue ID: 338 Category: General Reproducibility: sometimes Severity: minor Priority: normal Status: new ====================================================================== Date Submitted: 02-May-06 07:20 CEST Last Modified: 02-May-06 07:20 CEST ====================================================================== Summary: The header indication is broken in some MUA. some MUA. Description: If the headervalue length is over 255 bytes, the data up to 255 bytes is stored to the variable and the rest of the data is cut off by _header_cache() function in dbmail-message.c. I think that is because the dbmail_headervalue.headervalue type in mysql is VARCHAR(255). But, sometimes the end of encoded mime header (used well in mutli-byte mail) such as '?=' is lost. So, the header indication is broken in some MUA. In PostgreSQL, it is not necessary to cut off the part of data which exceeds 255 bytes because dbmail_headervalue.headervalue field type is TEXT. For that reaseon, I made the patch only for PostgreSQL (please see the attached file). Do you have any plan to change the dbmail_headervalue.headervalue type from VARCHAR(255) to TEXT or MEDIUMTEXT in the future? ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 02-May-06 07:20 ryo New Issue 02-May-06 07:20 ryo File Added: dbmail-headervalue-noclean.patch ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev