The mailwatch upgrade in 3.0.0.8 is supposed to support unicode.
When I send myself a message, the message list shows the same improperly decoded gibberish it always used to show.
e.g.
but I getSubject: chinese test: 中国
I was kinda hoping to see the original Chinese characters in the message list.Subject: chinese test: 谢谢
Am I doing something wrong, or do I have something misconfigured? Could it be my mysql databases are not utf8?
Code: Select all
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| efa |
| mailscanner |
| mysql |
| sa_bayes |
| sbtest |
| sbtest1 |
| sqlgrey |
+--------------------+
Code: Select all
+-------------+----------------------------------------------------------------------------------------------+
| Database | Create Database |
+-------------+----------------------------------------------------------------------------------------------+
| efa | CREATE DATABASE `efa` /*!40100 DEFAULT CHARACTER SET latin1 */ |
| mailscanner | CREATE DATABASE `mailscanner` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */ |
| sa_bayes | CREATE DATABASE `sa_bayes` /*!40100 DEFAULT CHARACTER SET latin1 */ |
| sqlgrey | CREATE DATABASE `sqlgrey` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+-------------+----------------------------------------------------------------------------------------------+
The https://efa.local/mailscanner/status.php page is in UTF8 encoding.
(if anyone else has working unicode displaying foreign characters in your mailscanner interface, I'd love to compare notes with you)