[Mimedefang] Re: sql integration of quarentine and others

[Steffen Kaiser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 18 Apr 2007, Danny Kjærgaard wrote:

> I got it narrowed down to that almost all the mails contains the multibyte
> char \x92. As debugging I put the subject,header and the entire mail into

I do not run mySQL myself, therefore I can only guess,

"longblob" is a Binary Large OBject, correct? Meaning -> The content is 
binary <stop>. No validation according character sets is performed.

Could it be your INSERT statement that chokes? In Postgres I always use 
prepared statements and I haven't found any problem with binary stuff till 
now.

Or do you extract information from the email and store it into other 
fields, that have a tighter encoding? Could you try to INSERT only one 
information after another to see which field causes the INSERT to break?

Bye,

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQEVAwUBRiX85OgJIbZtwg6XAQJk+Af/aVS4sqw9NpUz8Ma4p0oae9EXwP+C3O4i
amxFMSZK7EQOkOlwd/KhMigQsdnQ/Ugl0hQCuszjx6CWtVXOE3CNvSi7Nh2z8zeA
EMCeZbB+8aAcjSdSw7fYcLyHXxH1Qwpjl1iOmiaLo8NfDuWkFPbvvU5icbnG4Qn7
aAZhLmqYqM2HvZhLnUQx2xo5beFU+7OY4fh3qGnqdyufdEBahZduT5R9hfbGjVab
ARLtc8bsRZ3yeO0koYMPlGplpmOKPha8IzbbzvSL1wpVxLxXIe/gpctcbRWGgGiv
uMBnfALKvMtdCQCPM9lCFnGT97lJXLh5MdQlWQ7+CtWNz/ydia8pAw==
=+2nJ
-----END PGP SIGNATURE-----