Mysql实例mysql修改数据库编码(数据库字符集)和表的字符编码的方法

alter table tb_anniversary convert to character set utf8;

mysql> show variables like'character%';

+--------------------------+----------------------------+MYSQL教程

|Variable_name           |Value                     |MYSQL教程

+--------------------------+----------------------------+MYSQL教程

|character_set_client    |latin1                    |MYSQL教程

| character_set_connection |latin1                    |MYSQL教程

| character_set_database   |latin1                    |MYSQL教程

| character_set_filesystem |binary                    |MYSQL教程

|character_set_results   |latin1                    |MYSQL教程

|character_set_server    |latin1                    |MYSQL教程

|character_set_system    |utf8                      |MYSQL教程

|character_sets_dir      | /usr/share/mysql/charsets/ |MYSQL教程

+--------------------------+----------------------------+MYSQL教程

8 rows in set (0.00 sec)
MYSQL教程

[client]

#password      = your_passwordMYSQL教程

port           = 3306MYSQL教程

socket         = /var/lib/mysql/mysql.sockMYSQL教程

default-character-set=utf8     #设置默许编码为UTF8
MYSQL教程