设置mysql为utf-8_如何设置mysql数据库为utf-8编码

满意答案

ddddlyxy

.01.27

采纳率：47%等级：12

已帮助：12169人

方法一：

mysql> show variables like '%chara%';

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

| Variable_name | Value |

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

| character_set_client | gbk |

| character_set_connection | gbk |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | gbk |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | d:\mysql\share\charsets\ |

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

8 rows in set (0.00 sec)

mysql> set character_set_client=utf8

-> ;

Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_client=gbk;

Query OK, 0 rows affected (0.00 sec)

mysql>

方法二：

在my.ini或者f中改

10分享举报