Mysql creates a database and specifies the encoding format _ MySQL

Specify the encoding format when creating a database in mysql

When using SQL statements in mysql to create a database, you always forget to specify the encoding format. This leads to Chinese garbled characters during database access using UTF-8 engineering. Later, we found that most of the problems came from the absence of encoding formats when creating databases. One way to specify the encoding format for creating a database is to specify the encoding format in the SQL statement for creating a database, as shown in UTF-8 following code:

Create database 'test2' default character set utf8 COLLATE utf8_general_ci;