mysql里中文显示???请教高手怎么解决
发表于 : 2010-11-06 11:42
mysql里的字符串都设置为nvarchar类型,我的myeclipse使用了里面也使用了过滤器过滤字符为“utf8”。
页面也设置为pageEncoding="UTF-8"。页面输入到mysql的中文是正常的,在页面返回的查询结果也是正常的,但是 就是在命令行连接的mysql里面所有中文都显示???。
这是我在mysql里面收集到的有关编码的信息:
mysql> show VARIABLES like 'character_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
/etc/mysql/my.cn里面的配置如下:
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
default-character-set=utf8
collation-server=utf8_unicode_ci
skip-external-locking
到底错处在哪里?请高手指点
页面也设置为pageEncoding="UTF-8"。页面输入到mysql的中文是正常的,在页面返回的查询结果也是正常的,但是 就是在命令行连接的mysql里面所有中文都显示???。
这是我在mysql里面收集到的有关编码的信息:
mysql> show VARIABLES like 'character_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
/etc/mysql/my.cn里面的配置如下:
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
default-character-set=utf8
collation-server=utf8_unicode_ci
skip-external-locking
到底错处在哪里?请高手指点