mysql中命令行插入数据问题??求指导?
看图:
为啥插入不了数据?我的数据库是utf—8编码的,插入应该没问题啊?两个字段都是varchar类型的,
为啥插入不了数据?我的数据库是utf—8编码的,插入应该没问题啊?两个字段都是varchar类型的,
作者: alwaysFlyBoy 发布时间: 2011-05-28
抱歉,图没搞上,
-----+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | D:\Program Files\MySQL\MySQL Server 5.1\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
mysql> insert into tb_bbs (title,content) values('最新最流行韩寒小说','最新最流
行韩寒小说'); ; ;
ERROR 1366 (HY000): Incorrect string value: '\xD7\xEE\xD0\xC2\xD7\xEE...' for co
lumn 'title' at row 1
mysql>
-----+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | D:\Program Files\MySQL\MySQL Server 5.1\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
mysql> insert into tb_bbs (title,content) values('最新最流行韩寒小说','最新最流
行韩寒小说'); ; ;
ERROR 1366 (HY000): Incorrect string value: '\xD7\xEE\xD0\xC2\xD7\xEE...' for co
lumn 'title' at row 1
mysql>
作者: alwaysFlyBoy 发布时间: 2011-05-28
作者: ACMAIN_CHM 发布时间: 2011-05-28