phpmyadmin中mysql 中文查询显示问号

Web、Mail、Ftp、DNS、Proxy、VPN、Samba、LDAP 等基础网络服务
回复
头像
drylandfan
帖子: 38
注册时间: 2011-11-07 22:38

phpmyadmin中mysql 中文查询显示问号

#1

帖子 drylandfan » 2012-11-10 23:08

RT,所有操作都是在网页中进行的,在表中插入中文数据能显示插入成功,但是插入完成后表中中文显示问号
这是查询的结果,姓名是汉字但是显示问号
reader_id reader_name sex birthday phone mobile card_name card_id level day
r001 ?? ? 1988-03-07 62127790 13671100110 ??? 230106198803070178 ?? 2010-08-01

网上看的要修改/etc/mysql/my.conf,我弄了还是不行,以下是/etc/mysql/my.conf的内容
希望路过的各位大神不吝赐教,帮帮小弟吧!!!!!!!

代码: 全选

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
default-character-set=utf8

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking

character-set-server=utf8
#collation-server=utf8_general_ci

#default-character-set=utf8
skip-character-set-client-handshake


[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
default-character-set=utf8

[isamchk]
key_buffer		= 16M

头像
drylandfan
帖子: 38
注册时间: 2011-11-07 22:38

Re: phpmyadmin中mysql 中文查询显示问号

#2

帖子 drylandfan » 2012-11-10 23:10

代码: 全选

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/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)


头像
TeliuTe
论坛版主
帖子: 7668
注册时间: 2007-11-25 13:29
系统: 16/18/20/w7
来自: 新疆博乐
联系:

Re: phpmyadmin中mysql 中文查询显示问号

#3

帖子 TeliuTe » 2012-11-10 23:34

字段属性里的整理设为 utf8_unicode_ci
图片
回复