Stephen,
You can indeed select full unicode on a per database, (IIRC, even per-table basis).
The useful keywords for details are 'mysql' and 'utf8mb4'.
It is also possible to Alter existing databases and tables, but with one catch: the maximum table row length is reduced, so some tables will need to be adjusted (e.g. converting varchar(255) to varchar(230)).
Ruth
On 27/02/2021 12:36, Stephen J. Turnbull wrote:
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.)
-- Software Manager & Engineer Tel: 01223 414180 Blog: http://www.ivimey.org/blog LinkedIn: http://uk.linkedin.com/in/ruthivimeycook/