show variables like 'char%';Pour info, chez moi où il n'y a aucun problème, c'est :
mysql> show variables like 'char%'; +--------------------------+-------------------------------------------------+ | Variable_name | Value | +--------------------------+-------------------------------------------------+ | character_set_client | cp850 | | character_set_connection | cp850 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | cp850 | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | E:\wamp64\bin\mysql\mysql8.0.19\share\charsets\ | +--------------------------+-------------------------------------------------+ 8 rows in set (0.01 sec) mysql>
[wampmysqld64] character-set-server=utf8Sauver le fichier modifié et relancer le service wampmysqld64: