A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=401 ====================================================================== Reported By: yuen Assigned To: ====================================================================== Project: DBMail Issue ID: 401 Category: Database layer Reproducibility: sometimes Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 23-Aug-06 06:05 CEST Last Modified: 18-Sep-06 01:59 CEST ====================================================================== Summary: invalid byte sequence for dbmail_headervalue when database is utf-8 encoded Description: In 2.1.7 there are bytea type for messageblk, so I hope that I can finally use unicode based database, but dbmail-util -by throws errors on some headers, that contain non latin charakters: .......................................................................Error dbpgsql.c, db_query: Error executing query [INSERT INTO mail.dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,4638,'&http://www.dbmail.org/mantis/view.php?id=272;Ç&http://www.dbmail.org/mantis/view.php?id=262;Ú&http://www.dbmail.org/mantis/view.php?id=268;&http://www.dbmail.org/mantis/view.php?id=336;, 15 &http://www.dbmail.org/mantis/view.php?id=327;&http://www.dbmail.org/mantis/view.php?id=357;ÔÂ 2006 23:33:59 +0100')] : [ERROR: invalid byte sequence for encoding "UTF8": 0xd0c7
====================================================================== Relationships ID Summary ---------------------------------------------------------------------- related to 0000338 The header indication is broken in some... ====================================================================== ---------------------------------------------------------------------- paul - 03-Sep-06 14:34 ---------------------------------------------------------------------- This is most likely caused by incorrect truncation of these headervalues. Please test revision 2250. ---------------------------------------------------------------------- yuen - 18-Sep-06 01:59 ---------------------------------------------------------------------- header values are ok in 2270, but there are exactly same problems with cached envelopes :( Issue History Date Modified Username Field Change ====================================================================== 23-Aug-06 06:05 yuen New Issue 24-Aug-06 02:20 yuen Issue Monitored: yuen 03-Sep-06 14:32 paul Relationship added related to 0000338 03-Sep-06 14:34 paul Note Added: 0001388 18-Sep-06 01:59 yuen Note Added: 0001405 ======================================================================