UTF-8 support using MySQL as backend

English mAirList 6.x
1

I’m running into issues with character encoding. My database is running on MySQL /MariaDB backend with utf-8 unicode as collate. But when saving an entry I entered using the database app it gives me some strange characters within database , the apps or the metadata. What other things can I look after to see where the issue can be found?

Screenshot 2021-12-31 184159
Screenshot 2021-12-31 1841592156×72 67.2 KB

2

image
image972×150 28.1 KB

As you can see in the mysql database everything looks good. Any suggestions what can be wrong?

3

@Torben Connecting from mairlist with mariadb / mysql server and utf8 unicode collate and characterset=utf8 in the advanced options it works like a charm.
Except … with remote database management problem remains…

4

I assume you mean the computer running Professional Manage license?

Does it access the SQL directly, or through the mAirListDB Server application?

5

Trough the mAirlistDB server application

6

Did you remember to restart DBServer after adding the UTF8 option, so that it picks up the new configuration?

7

Ah , excellent. Too obvious but okay. Thanks for your assistance.