MySQL creates a database of the specified character set

Take the example of creating a database with a character set of UTF8:

CREATE DATABASE db_name DEFAULT CHARACTER SETUTF8 COLLATE utf8_general_ci;CREATE DATABASEThe syntax:CREATE{DATABASE | SCHEMA}[IF not EXISTS] db_name[create_specification [, Create_specification] ...] Create_specification:[DEFAULT] CHARACTER SETCharset_name| [DEFAULT]COLLATE collation_name

Change the character encoding of a database

ALTER DATABASE db_name DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci




MySQL creates a database of the specified character set