Ubuntu下mysql不能显示中文解决方法

来源：互联网发布：python dict get函数编辑：程序博客网时间：2024/05/02 01:54

问题:Ubuntu下mysql中文显示为?

查看字符集:

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

| character_set_system | utf8 |

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

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

然后修改配置:gedit /etc/mysql/my.cnf

找到［client]在下面加入
default-character-set=utf8
找到 [mysqld_safe]在下面加入
default-character-set=utf8
找到[mysqld]在下面加入
character-set-server=utf8
找到［mysql］在下面加入
default-character-set=utf8

改完后重新插入中文还是显示为?,这是因为你建立数据库时字符集已经设置为拉丁字符集了,删除数据库,重新建立数据库和表,在插入中文就可以正常显示了,此时的字符集为:

2.mysql> show variables like 'character%';

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

| 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/share/mysql/charsets/ |

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

0 0