MySQL view encoding format and modify encoding format

1. Enter MySQL to show variables like ‘character%‘; view the current character set encoding, as shown below:

Among them, Character_set_client is the client coding mode;

Character_set_connection the encoding used to establish the connection;

Coding of character_set_database database;

Character_set_results the encoding of the result set;

Character_set_server the encoding of the database server;

As long as the above four is guaranteed to use the same encoding method, there will be no garbled problem.

2. Modify the encoding format of the database

Method One: The command is: set character% = UTF8;

For example: Set Character_set_client =utf8;

However, this modification is only temporary, limited to the current session, and will expire once the database exits.

Method Two: Modify the my.cnf file

Command: VI/ETC/MY.CNF (hint: the exact location of the My.cnf file varies depending on the installation version or system)

Find [client] Add:

Default-character-set=utf8

Find [mysqld] Add:

Default-character-set=utf8

Then restart the MySQL service.

However, at this point, MySQL does not start at all

Workaround: Reopen the my.cnf file,

Find [mysqld]:

Change Default-character-set=utf8 to Character-set-server=utf8

Restart MySQL, log in to MySQL again, enter the command: Show variables like ' character% '; View the encoding and find that the encoding has changed to UTF8

MySQL view encoding format and modify encoding format