mysql 修改character_set_server为utf-8的解决办法

这篇文章主要为大家详细介绍了mysql 修改character_set_server为utf-8的简单示例，具有一定的参考价值，可以用来参考一下。

查看数据库编码如下：

mysql> show variables like '%char%';

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

| 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     | latin1                           |

| character_set_system     | utf8                             |

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

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

8 rows in set
-- End www.512pic.com(五一二笔记)

其中：

character_set_server     | latin1

编码为latin1，数据库出现中文乱码！

解决方法：

修改编码为uft8;

set @@character_set_server='utf8';

注：关于mysql 修改character_set_server为utf-8的简单示例的内容就先介绍到这里，更多相关文章的可以留意