MySQL command line interface Encoding

When executing commands on the MySQL command line interface, remember to set the encoding. Another unpleasant thing is that the last setting on the command line does not exist when you go in next time and you have to set it every time.

 

Set encoding:

# Log on to MySQL

Mysql-hxxx. XXX-Utest-P

 

-- Enter the password

 

Mysql>/s

Generally, the following information is displayed:

 

We can see two of the four types of encoding are utf8 and Latin1. In this case, if you operate Chinese, it will be as garbled as you think!

In order not to disturb the garbled characters, you can change the encoding:

 

 

 

This is why we can see that all codes are unified. Of course, there will be no problems in subsequent operations.

For example, source> XXX. SQL operations