The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=249 ====================================================================== Reported By: el-mangusto Assigned To: aaron ====================================================================== Project: DBMail Issue ID: 249 Category: installation scripts Reproducibility: always Severity: major Priority: normal Status: resolved Resolution: fixed Fixed in Version: 2.0 branch ====================================================================== Date Submitted: 18-Aug-05 00:16 CEST Last Modified: 29-Apr-06 23:25 CEST ====================================================================== Summary: Wrong SQL database script for MySQL Description: I found this bug during my work with russian language. Englsh messages works fine but the russian message bodies was completely lost. ======================================================================
---------------------------------------------------------------------- aaron - 18-Aug-05 00:23 ---------------------------------------------------------------------- Apparently the same UNICODE issue that we have with PostgreSQL. If we can handle this by specifying and/or checking the charset at connection time, I would prefer that to changing the database scripts. ---------------------------------------------------------------------- aaron - 18-Aug-05 00:28 ---------------------------------------------------------------------- At connection time: SET CHARACTER SET ascii; should do the trick. ---------------------------------------------------------------------- aaron - 29-Apr-06 23:25 ---------------------------------------------------------------------- Apparently messageblk was changed to longblob a long time ago in the 2_0 branch and in trunk. Issue History Date Modified Username Field Change ====================================================================== 18-Aug-05 00:16 el-mangusto New Issue 18-Aug-05 00:23 aaron Note Added: 0000840 18-Aug-05 00:28 aaron Note Added: 0000841 29-Apr-06 23:25 aaron Status new => resolved 29-Apr-06 23:25 aaron Fixed in Version => 2.0 branch 29-Apr-06 23:25 aaron Resolution open => fixed 29-Apr-06 23:25 aaron Assigned To => aaron 29-Apr-06 23:25 aaron Note Added: 0001120 ======================================================================
