How to modify the encoding of fields in tables and tables in MySQL database _ MySQL

The method for modifying the encoding of fields in tables and tables in MySQL database adds Chinese data to a table in MySQL database today, but there is always an exception. check the program for no errors, later, I checked the table again and found that the encoding method of the table was latin1 and the encoding method of the field that I originally wanted to insert Chinese characters into was also latin1. then I checked the exceptions in the console again, further confirmation is caused by improper field encoding in the table and table. modify the corresponding field in the table and find it online for a while, after the SQL script is executed, it can be saved to Chinese characters. However, we still think that it is necessary to sum up, the ancients cloud: good memory is not as good as bad writing.

Modify the TABLE encoding method: alter table 'test' default character set utf8; this command is used to change the TABLE test encoding method to utf8;

Modify the Field Encoding method: alter table 'test' CHANGE 'name' VARCHAR (36) character set utf8 not null; this command is used to change the name field encoding method in the test table to utf8.