Let's talk about database collation.
My testpage uses MySQL. The general collation of the database is "latin1_swedish_ci".
The tables have their own collations:
_comproifiler_... -> latin1_swedish_ci
all other joomla tables -> utf8mb4_unicode_ci
jem tables -> utf8_general_ci