The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=272 ====================================================================== Reported By: sn Assigned To: paul ====================================================================== Project: DBMail Issue ID: 272 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: resolved Resolution: fixed Fixed in Version: ====================================================================== Date Submitted: 23-Sep-05 01:53 CEST Last Modified: 01-Oct-05 14:53 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. ---------------------------------------------------------------------- sn - 01-Oct-05 11:29 ---------------------------------------------------------------------- We have change the type from longtext to longblob. IMHO it's more correct than us-ascii encoding. ---------------------------------------------------------------------- sn - 01-Oct-05 11:33 ---------------------------------------------------------------------- please, see my comment. ---------------------------------------------------------------------- paul - 01-Oct-05 14:52 ---------------------------------------------------------------------- I concur. Changed in SVN. ---------------------------------------------------------------------- paul - 01-Oct-05 14:53 ---------------------------------------------------------------------- changed dbmail_messageblks.messageblk from longtext into longblob for mysql's create scripts. Issue History Date Modified Username Field Change ====================================================================== 23-Sep-05 01:53 sn New Issue 01-Oct-05 10:55 paul Note Added: 0000929 01-Oct-05 11:29 sn Note Added: 0000938 01-Oct-05 11:33 sn Issue Monitored: paul 01-Oct-05 11:33 sn Note Added: 0000939 01-Oct-05 11:33 sn Issue Monitored: sn 01-Oct-05 14:52 paul Note Added: 0000940 01-Oct-05 14:53 paul Status new => resolved 01-Oct-05 14:53 paul Resolution open => fixed 01-Oct-05 14:53 paul Assigned To => paul 01-Oct-05 14:53 paul Note Added: 0000941 ======================================================================
