EF operation MySQL Chinese garbled problem

1. Ensure that MySQL data is encoded as UTF8

Start MySQL

Mysql-hlocalhost-uroot-p

Enter password

Show VARIABLES like ' character_% ';

SET character_set_client=' UTF8 ';

SET character_set_connection=' UTF8 ';

SET character_set_results=' UTF8 ';

2. The database has been generated, note the collation of the database, the collation of the table, and the collation of the string column in the table are UTF8

2. Add character Set=utf8 in the EF connection string

2. <connectionStrings>
4. <add name="mycontext"
6. connectionstring= "SERVER=127.0.0.1;PORT=3306;DATABASE=XXX;UID=XXX;PWD=XXX; Character set=UTF8; "
8. providername="MySql.Data.MySqlClient"/>
10. </connectionStrings>

EF operation MySQL Chinese garbled problem