Weblate MariaDb has the wrong charset
Originally created by @emmapeel on #16453 (Redmine)
today intri noticed that the weblate database has a weird charset for something about localisation ( latin1 )
In the weblate docs ( https://docs.weblate.org/en/latest/admin/install.html?highlight=charset%20database#unicode-issues-in-mysql ) it says that the charset should be `utf8mb4`:
ALTER DATABASE weblate CHARACTER SET utf8mb4;
But "Using this charset might however lead to problems with the default MySQL server settings, as each character now takes 4 bytes to store, and MySQL has an upper limit of 767 bytes for an index. In case this happens you will get one of the following error messages:
- 1071: Specified key was too long; max key length is 767 bytes
- 1709: Index column size too large. The maximum column size is 767 bytes.
And there are some workarounds that should be evaluated.