My table collations are set to utf8mb4_unicode_ci throughout, as I understood this to currently be the most universally compatible.
But for some languages this doesn't produce the correct data sorting.
I have read that for MySQL the collation can be set during database connection.
I expected to find a collation setting in the language file but I didn't see one.
Do I have to accept incorrect data sorting, or does PHPmaker have a way for me to define the collation for each language?