I was trying to upload a txt file (Unix UTFD encoded) to MariaDB and the UTF characters didn't display properly. Someone tried to use the data and displayed it on a web page with explicit tag defining the data as UTF and it displayed properly.
Example from the text file: Großhöflein
displays as follows in HeidiSQL data viewing tab: GroÃŸhÃ¶flein
The collation in the table is utf8mb64_general_ci
Is there a way to fix that display in the settings?
I have attached an extract of the source file that includes the above example (PS I tried to attach a zipped version but the file type was not accepted).