mysql 修改编码方式_Mysql编码方式修改

Mysql编码方式修改

使用mysql插入中文乱码：

mysql> select name from info;

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

| name |

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

| ?? |

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

1 row in set (0.00 sec)

mysql>

1.修改配置文件的方式修改：

找到mysql下的my.conf

1.在[mysqld]下添加：

character_set_server=utf8

2.重启mysql服务

3.查看编码方式：

mysql> show variables like 'character%';

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

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

| character_set_system | utf8 |

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

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

8 rows in set (0.00 sec)

4.插入数据后查看

mysql> select name from info;

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

| name |

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

| ?? |

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

| 中国 |

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

2 row in set (0.00 sec)

mysql>

2.以命令的方式修改：

1.已修改配置文件后mysql更改的编码属性为例，我们需要使用命令

set character_set_client=’utf8’ 的方式分别设置一下几个参数的编码方式：

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

2.或使用set names 'utf8'; 也可直接设置大部分属性