A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=426 ====================================================================== Reported By: yuen Assigned To: ====================================================================== Project: DBMail Issue ID: 426 Category: Database layer Reproducibility: sometimes Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 08-Oct-06 23:52 CEST Last Modified: 31-Oct-06 14:38 CET ====================================================================== Summary: invalid byte sequence for encoding "UTF8" for evelope table Description: There are still errors on inserting to evelope table, so I'm creating this separate bug report. ======================================================================
---------------------------------------------------------------------- aaron - 09-Oct-06 01:38 ---------------------------------------------------------------------- Please provide data that causes this error message. ---------------------------------------------------------------------- yuen - 11-Oct-06 15:33 ---------------------------------------------------------------------- I have sent some errors in file attachment, if you would more I can send full log (1Mb) ---------------------------------------------------------------------- paul - 11-Oct-06 16:22 ---------------------------------------------------------------------- Plz don't send 1mb logs. But do include a message that is causing this. ---------------------------------------------------------------------- paul - 27-Oct-06 14:51 ---------------------------------------------------------------------- yuen, I've committed a change in dbmail_2_2_branch that should fix this. Please let me know if it works. ---------------------------------------------------------------------- yuen - 30-Oct-06 21:05 ---------------------------------------------------------------------- I have tried 2333, but there are still same errors ---------------------------------------------------------------------- paul - 30-Oct-06 22:50 ---------------------------------------------------------------------- Yuen, Please provide us with a raw message so we can reproduce this more exactly. It can't be the exact same error. Please add some logs from current svn. ---------------------------------------------------------------------- paul - 31-Oct-06 14:38 ---------------------------------------------------------------------- Forget about my last message. I've changed the code so that now values are converted to utf8 before insertion into the database. My previous change did utf7 encoding to avoid pgsql breakage, but storing values like subjectfield as utf7 would break the SORT capability. Please test the lastest (rev 2346) and post some logs if it still breaks for you. This actually means that utf8 encoding will be required for dbmail-2.2+ which is probably not a bad thing. Issue History Date Modified Username Field Change ====================================================================== 08-Oct-06 23:52 yuen New Issue 09-Oct-06 01:38 aaron Note Added: 0001484 09-Oct-06 11:54 yuen File Added: envelope.err 11-Oct-06 15:33 yuen Note Added: 0001498 11-Oct-06 16:22 paul Note Added: 0001499 27-Oct-06 14:51 paul Note Added: 0001510 30-Oct-06 21:05 yuen Note Added: 0001513 30-Oct-06 22:50 paul Note Added: 0001514 31-Oct-06 14:38 paul Note Added: 0001515 ======================================================================
