Troubleshoot MySQL Chinese display

1. Check the MySQL character setting: If it is not GBK, make the relevant 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 the database, select table settings, such as

3 But the question is whether to show or error, try: SELECT ' payroll total ', sum (fsalary) from T_employee;

This is the right time to show, and later on is not the UNION of the problem, and then try: SELECT ' official employee maximum age ', Max (Fage) as ' age ' from T_employee UNION SELECT ' official employee minimum Age ', min ( FAGE) from T_employee; The statement is also correct.

The problem is that the field type is set, and the attempt is still incorrect. And now I don't know why.

Troubleshoot MySQL Chinese display