How to change the character Encoding of a Database by mysql

This article mainly describes how mysql changes the character encoding of the database, has a certain reference value, and friends who need it can refer to it. I hope you all have a lot to gain after reading this article. Let's take a look at it together.

mysql to change the database character encoding method: first call up "run", enter cmd; then log in to the database, view the database; finally modify the database character set, the code is [mysql>use mydb].

mysql How to change database character encoding:

1. Win+R, call up "Run", enter cmd, Enter

2, mysql change the database character encoding method

Log in to the database,

3. View the database

4. View database character codes

5. Modify through 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;

6 and of course:

mysql>use mydb

mysql>alter database mydb character set utf8;

7. Create a database Specify the character set of the database

mysql>create database mydb character set utf8; Thank you for reading this article carefully, I hope Xiaobian share mysql how to change the character encoding content of the database is helpful to everyone, but also hope that everyone will support more, pay attention to the industry information channel, find problems encountered, detailed solutions waiting for you to learn!