UTF encoded data

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).

Cheers, Gaetano.

Your file looks like a normal utf8 file here. Perhaps you did not select the right encoding of the file when opening it in HeidiSQL. Be sure not to select "Auto-detect":