这是用ECHO $SQL看到的东西:
insert into users (users,passwords,name,usertype,xb,xjh,jtzz,xh) values ('0509017073','0509017073','黄晨','1','1','0509017073','玉阳镇子龙路30号','')以下是错误原因:
Incorrect string value: '\xBB\xC6\xB3\xBF' for column 'name' at row 1能在PHP内部设定CSV的编码吗?
insert into users (users,passwords,name,usertype,xb,xjh,jtzz,xh) values ('0509017073','0509017073','黄晨','1','1','0509017073','玉阳镇子龙路30号','')以下是错误原因:
Incorrect string value: '\xBB\xC6\xB3\xBF' for column 'name' at row 1能在PHP内部设定CSV的编码吗?
如果是MySQL的话,用set names "GBK"设置编码
导入csv文件的数据,用iconv转换csv的编码为GBK
iconv("原来的编码", "GBK", $string);