When MySQL creates a child view and looks at it, the character set error problem

Enter command-line mode,

If the MySQL database is already installed, you can use the following SQL command to view the current character set settings for MySQL:
Mysql> Show variables like ' character_set_% ';

+--------------------------+--------------------------------------------------+
| variable_name | Value |
+--------------------------+--------------------------------------------------+
| character_set_client | UTF8 |
| character_set_connection | UTF8 |
| Character_set_database | gb2312 |
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | D:\wamp2.5\bin\mysql\mysql5.6.17\share\charsets\ |
+--------------------------+--------------------------------------------------+

Execute in turn:

Set Character_set_client =gb2312;
Set Character_set_connection =gb2312;
Set Character_set_database =gb2312;
Set Character_set_results =gb2312;
Set Character_set_server =gb2312;

Problem Solving!

When MySQL creates a child view and views it, the character set error problem