Ubuntu的linux系统中,数据库中文转为???的解决方法如下:
1. 打开my.cnf文件:
>gedit /etc/mysql/my.cnf
2. 添加如下内容:
[mysqld]
[client]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
[mysql]
default-character-set=utf8
3. 重启mysql服务:
>service mysql restart # restart mysql serve