Mysql insert,update等有中文时出错
程序猿DD Java领域优质创作者 博客专家认证 2009-04-09 12:35:38 Connection id: 5
Current database: shop
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.30-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: gb2312
Db characterset: gb2312
Client characterset: gb2312
Conn. characterset: gb2312
TCP port: 3306
Uptime: 57 sec
对shop该数据库,现在的配置如上,characterset gb2312,gbk,utf8都试过了,
每次执行 update admin set admin_namec=N'的' where admin_id= 1;时,都会报
ERROR 1366 (HY000): Incorrect string value: '\xB5\xC4' for column 'admin_namec'
at row 1
谁知道该怎么解决啊?并且这种情况,数据是不会进数据库的