Mysql character encoding settings

Mysql character encoding settings

Inserting Data in mysql always displays ??? Garbled text. Many people on the Internet said that the trial was not correct. After a large amount of query information, they wrote the Solution Below. Different versions have different solutions. My database version (5.5.40)

[Client]

Default-character-set = utf8
[Mysql]
Default-character-set = utf8
[Mysqld]
Collation-server = utf8_unicode_ci
Init-connect = 'set NAMES utf8 ′

Character-set-server = utf8