v3.0.0.8 mailwatch unicode support
Posted: 15 Aug 2015 09:30
Hi Shawn,
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.
Am I doing something wrong, or do I have something misconfigured? Could it be my mysql databases are not utf8?
show create database (*)
Will the non UTF8 databases cause this problem?
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)
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)