[Mimedefang] Re: sql integration of quarentine and others

[David F. Skoll]

Danny Kjærgaard wrote:

> I got it narrowed down to that almost all the mails contains the multibyte
> char \x92.

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

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.

(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.)

Regards,

David.