mysql不能显示中文字符串_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>

极度郁闷中。。。

问题补充

不是，我用的是mysql Client

问题补充：

mysql> show create table a;

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

| Table | Create Table

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

| a     | CREATE TABLE `a` (

`name` varchar(20) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

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

1 row in set (0.00 sec)

mysql> select * from a;

Empty set (0.00 sec)

mysql> insert into a values('你');

ERROR 1406 (22001): Data too long for column 'name' at row 1

mysql>

好像这是mysql的问题，字符集不应该有问题

2009年7月16日 22:02

15

0

0

0