Solve mysql Chinese display
1. view the mysql character setting method, as shown in. If it is not gbk, perform related settings.
Mysql> SET character_set_client = gbk;
Mysql> SET character_set_connection = gbk;
Mysql> SET character_set_database = gbk;
Mysql> SET character_set_results = gbk;
Mysql> SET character_set_server = gbk;
Mysql> SET collation_connection = gbk_bin;
Mysql> SET collation_database = gbk_bin;
Mysql> SET collation_server = gbk_bin;
2. Select database and table settings, as shown in figure
3. If the problem persists, try the following statement: SELECT "total salary", SUM (FSalary) FROM T_Employee;
Now it is correctly displayed, and later I was wondering if it was a union problem, so I tried again: SELECT "the highest age for formal employees", MAX (FAge) as 'age' FROM T_Employee union select 'minimum formal employee age', MIN (FAge) FROM T_Employee; statement is also correct.
I thought it was a field type setting problem, but it was still incorrect after the attempt. I don't know why.