The MySQL setting is encoded as UTF8, and the setting table is UTF8.

1. Set the encoding to UTF-8

SetCharacter_set_client=UTF8;SetCharacter_set_server=UTF8;SetCharacter_set_connection=UTF8;SetCharacter_set_database=UTF8;SetCharacter_set_results=UTF8;SetCollation_connection=utf8_general_ci;SetCollation_database=utf8_general_ci;SetCollation_server=Utf8_general_ci;

2. Set the table to UTF-8

ALTER TABLE Tb_anniversary convert to character set UTF8;

　　

3. When creating a new database, set the library to UTF-8

Create Database character Set

 

The MySQL setting is encoded as UTF8, and the setting table is UTF8.