ubuntu mysql 编码 命令_ubuntu12.04.4中在mysql控制台下通过命令设置编码

终端进入mysql控制台：

mysql

或

mysql --user=root -p

或

mysql -u root -p

1. 查看编码：

SHOW VARIABLES LIKE 'character_set_%';

或(推荐用上面的命令查看编码)：

\s

2. 修改编码：

SET character_set_database = utf8;

SET character_set_server = utf8;

SET character_set_client = utf-8;

3. 如下：

mysql> 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)

mysql> SET character_set_database = utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> SET character_set_server = utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'character_set_%';

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

| Variable_name | Value |

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

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysql/share/charsets/ |

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

8 rows in set (0.00 sec)

mysql>

4. OK， Enjoy it!!!