Modify database Character Set __ database

If you do not configure the MySQL environment variable in cmd, then in the system advanced settings where the MySQL environment variable settings. 2

Win+r, pull up "run", enter CMD, carriage return

3

Log in to the database,

4

View Database

5

View Database character encoding

6

modify via MySQL command line: (encoding optional)

Mysql> set Character_set_client=utf8;

Mysql> set Character_set_connection=utf8;

Mysql> set Character_set_database=utf8;

Mysql> set Character_set_results=utf8;

Mysql> set Character_set_server=utf8;

Mysql> set Character_set_system=utf8;

Mysql> set Collation_connection=utf8;

Mysql> set Collation_database=utf8;

Mysql> set Collation_server=utf8;

7

Of course there are:

Modify the database's character set Mysql>use mydb

Mysql>alter database mydb character set UTF8;

8

Create a database specify the character set of the database

Mysql>create database mydb character set UTF8;