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

来源：互联网发布：淘宝店铺装修网站编辑：程序博客网时间：2024/06/12 00:16

终端进入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!!!

0 0