Mysql modifies the database encoding (database character set) and Table character encoding methods, mysql Character Set

Mysql modifies the database encoding (database character set) and Table character encoding methods, mysql Character Set

Mysql database is an open-source database and is widely used. The following describes how to modify the character encoding of the mysql database and convert the character encoding of the table to UTF-8. For more information, see.

Mysql converts the character encoding of a table to UTF-8:

alter table tb_anniversary convert to character set utf8;

Modify mysql character encoding to UTF8:

Step 1: view the current character encoding method:

　　　　

mysql> show variables like'character%';+--------------------------+----------------------------+|Variable_name           |Value                     |+--------------------------+----------------------------+|character_set_client    |latin1                    || character_set_connection |latin1                    || character_set_database   |latin1                    || character_set_filesystem |binary                    ||character_set_results   |latin1                    ||character_set_server    |latin1                    ||character_set_system    |utf8                      ||character_sets_dir      | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec)

When the character encoding is latin1, you insert a character type (char) record to the data table. When this record is displayed, data of the character type may not be displayed normally, therefore, we can change the mysql character encoding to UTF8. The procedure is as follows:

Step 2: Modify the my. cnf configuration file as follows (/etc/my. cnf ):

[Client] # password = your_passwordport = 3306 socket =/var/lib/mysql. sockdefault-character-set = utf8 # set the default encoding to UTF8

To query the details of each field in the current table: show full columns from table_name;