Message size is limited to 64kB when using MySQL

[jonas]

The email payload is stored in the database using a sqlalchemy BLOB column. Unfortunately it appears that the MySQL BLOB datatype is limited to storing 64kB of data. This is bad news since a lot of email messages are larger than that and we'll need to find a way to use the MySQL specific datatype LONGBLOB instead.

The following command can be used to switch to using LONGBLOB:

ALTER TABLE msg MODIFY COLUMN payload LONGBLOB;

http://groups.google.com/group/posterity/browse_thread/thread/491eaf5c73ff48dc