Umlauts in MySQL

Question

MySQL

Faced a curious problem:
There is a database with data collected from German sites in UTF8 encoding.
If you do data sampling through PHP, then everything is displayed correctly in the browser.
However, if you connect to the database with the console or go through the Windows MySQLFront,
then instead of umlauts, such curious characters are displayed - ü.
The console, client and database are set to UTF8 encoding.
I rummaged through half-google but did not find a solution.

Answer 1

in the font that is used in the terminal on the side closest to you, are these characters exactly there? Do you type them from the keyboard or copy-paste?
I would sin on the font, but if everything is ok with it, then the output of locale and show variables like 'character%'; to the studio!

Answer 2

mysql-front.software.informer.com/5.0/ here they write that MySQLFront has problems with utf-8 ...
PS just in case, make sure that SHOW CREATE TABLE shows that the table and its fields use utf-8. character_set_database is just the default character set for the given database, nothing more.