I always use UTF8MB4 for all.
If you use phpmyadmin you can change everything on the spot.
UTF8MB4 works great with LC, it's just you need to encode and decode
correct in LC when you send or retrieve data.
I always use PHP files as middleware. So LC sends to the PHP file, and
the PHP file
Thank you Matthias,
because it is an existing db and years old LC programs in different versions
out at the customers, I can't modify my old LC programs out there.
I now have read that uft8 gets deprecated in mySQL 8 at some time, so that all
new and migrated mySQL 8 databases gets by default