1. Enter the following code under SQLyog and execute all
SET character_set_client = utf8;
SET character_set_results = gb2312;
SET character_set_connection = utf8;
If the above does not work, try Can be changed to Gbk. Just change the text encoding of your data to the corresponding encoding type and you'll be fine. The code for Gbk is given:
SET character_set_client = gbK;
SET character_set_results = gbK;
SET character_set_connection = utf8;
But it doesn’t work again after restarting SQL.
2.Tools->Preference Base->Editor Modify Fonts
After the modification is completed, just restart SQLyog!