A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=272 ====================================================================== Reported By: sn Assigned To: ====================================================================== Project: DBMail Issue ID: 272 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new ====================================================================== Date Submitted: 23-Sep-05 01:53 CEST Last Modified: 01-Oct-05 10:55 CEST ====================================================================== Summary: Non-UTF characters in a mesaage's body Description: Table: dbmail_messageblks. Column: messageblk. The default type of this column is longtext and encoding -- utf8. When message is not in UTF encoding (KOI8-R for example), dbmail tries to insert it as is. But mysql, does'n allow to insert non-UTF characters in utf longtext type column.
IMHO, there are two ways to solve it: 1) Change type of messageblk to longblob 2) Convert message to UTF on the fly. mysql version: 4.1.11a-4sarge1 ====================================================================== ---------------------------------------------------------------------- paul - 01-Oct-05 10:55 ---------------------------------------------------------------------- Using us-ascii as encoding for the dbmail_messageblks table instead of utf-8 will probably resolve this. This very same problem has been reported on pgsql many times, and changing the encoding to us-ascii has always been effective. Issue History Date Modified Username Field Change ====================================================================== 23-Sep-05 01:53 sn New Issue 01-Oct-05 10:55 paul Note Added: 0000929 ======================================================================
