How to set sqlyog Chinese garbled characters. 1. enter the following code in SQLyog and execute SETcharacter_set_clientutf8; encode; SETcharacter_set_connectionutf8; if the above code does not work, run the following code in SQLyog:
SET character_set_client = utf8;
SET character_set_results = gb2312;
SET character_set_connection = utf8;
If not, you can change it to Gbk. It is okay to change the encoding type according to the text encoding of your data. Provide the Gbk code:
SET character_set_client = gbK;
SET character_set_results = gbK;
SET character_set_connection = utf8;
However, the SQL statement cannot be restarted.
2. Tools-> Preference Base-> Editor modify Fonts
After modification, restart SQLyog!
Optional SET character_set_client = utf8; SET character_set_results = gb2312; SET character_set_connection = utf8; if the above does not work, you can also...
