Brian Carpenter writes:
Are there still any outstanding issues with using MySQL? I know I ran into some when I tried to use MySQL and chose to go with PostgreSQL (which I am so glad I did). I still recall even seeing some recent issues brought to this list for someone using MySQL.
As far as I know the "emoji" problem (MySQL doesn't handle Unicode characters outside of the Basic Multilingual Plane by default) is still present. Given that emoji are now in use by pretty much everybody and easily accessible on most platforms, this default is unfortunate. However, I believe this is a server-wide setting, so I am dubious that Mailman should force the "full Unicode" setting on. (Anybody who knows feel free to correct me.)
The other problem, that Mailman assumes something about ordered results in subqueries that many SQL databases happen to conform to but is not part of the standard, and MySQL does *not* implement, has been fixed in Mailman (and released, I believe).
Steve