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谁知道该怎么解决啊?并且这种情况,数据是不会进数据库的
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谁知道该怎么解决啊?并且这种情况,数据是不会进数据库的
用过,没用,UTF,GBK,都试过Server characterset: gb2312
Db characterset: gb2312
Client characterset: gb2312
Conn. characterset: gb2312 个人认为配置应该都没问题啊