MySQL无法显示中文,编码设成utf-8也不行!

MySQL5.0.18无法显示中文,编码设成utf-8也不行!
mysql> create table aaa(name varchar(20));
Query OK, 0 rows affected (0.10 sec)

mysql> show create table aaa;
+-------+--------------------------------------------------------
| Table | Create Table
+-------+--------------------------------------------------------
| aaa | CREATE TABLE `aaa` (
`name` varchar(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------
1 row in set (0.00 sec)

mysql> insert into aaa values('你在哪里啊?');
ERROR 1406 (22001): Data too long for column 'name' at row 1
mysql> insert into aaa values('你在');
ERROR 1406 (22001): Data too long for column 'name' at row 1
mysql> insert into aaa values('你');
ERROR 1406 (22001): Data too long for column 'name' at row 1
mysql>

之后我又试了set session sql_mode='';能插入,但是无法正常显示,五六个的中文汉字结果只能显示出一两个乱码!

再之后,我安装了mysql 5.1.34 下,我所用的编码方式为utf-8,结果与上不同,但一样不支持中文,只有在gbk和gb2312下才能插入并显示正确:

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 | D:\Java\MySQL5\share\charsets\ |
+--------------------------+--------------------------------+
8 rows in set (0.00 sec)

mysql> create table a(name varchar(10));
Query OK, 0 rows affected (0.07 sec)

mysql> insert into a values('完全');
ERROR 1366 (HY000): Incorrect string value: '\xCD\xEA\xC8\xAB' for column 'name' at row 1
mysql> set session sql_mode='';
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values('完全');
Query OK, 1 row affected, 1 warning (0.04 sec)

mysql> select * from a;
+------+
| name |
+------+
| |
+------+
1 row in set (0.00 sec)

mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values('完全');
Query OK, 1 row affected (0.05 sec)

mysql> select * from a;
+------+
| name |
+------+
| |
| 完全 |
+------+
2 rows in set (0.02 sec)

mysql>


极度郁闷中。。。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值