[Mimedefang] Re: sql integration of quarentine and others

[Danny Kj=?ISO-8859-1?B?5g==?=rgaard]

> What database are you using?  Maybe it has a database encoding that it wants
> the e-mail to be in?
Mysql 5.0

> 
> We solved the problem by Base64-encoding the entire e-mail before stuffing
> it into the database.  It wastes space, but is guaranteed not to cause
> encoding problems.

Hmmm base64 might be a better solution.

> 
> (Actually, our upcoming solution is a dedicated storage-manager daemon
> for storing e-mail bodies; it's not efficient to stuff large chunks of random
> text into most databases.)

Yeah that's my problem right now. The next step might be to reduce then
longtext, to mediumtext, but still this have insane search times, and it's
not the positive insane.

Cheers.
-Danny