MySQL Modify the database character set, encode

View MySQL Database current encoding

Mysql-uroot-pxxx

Use tigercity;

Show variables like ' character_set_database ';

MariaDB [lottery]> Show variables like ' character_set_database ';

+------------------------+--------+

| variable_name | Value |

+------------------------+--------+

| Character_set_database | Latin1 |

+------------------------+--------+

1 row in Set (0.01 sec)

Show variables like ' character_set_% ' wildcard match

MariaDB [lottery]> Show variables like ' character_set_% ';

+--------------------------+----------------------------------+

| variable_name | Value |

+--------------------------+----------------------------------+

| character_set_client | UTF8 |

| character_set_connection | UTF8 |

| Character_set_database | Latin1 |

| Character_set_filesystem | binary |

| Character_set_results | UTF8 |

| Character_set_server | Latin1 |

| Character_set_system | UTF8 |

| Character_sets_dir | /usr/local/mysql/share/charsets/|

+--------------------------+----------------------------------+

8 rows in Set (0.00 sec)

Modify the encoding method one,

ALTER DATABASE lottery character set UTF8;

Immediate effect, again show variables like ' character_set_database ';

Method Two,

Vim/etc/my.cnf

[Mysqld]

Character_set_database=utf8

Character_set_server=utf8

Then restart the MySQL service

Service mysqld Restart

MySQL Modify the database character set, encode