Create DATABASE shopping2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;use shopping2;create table font(a varchar(100)); 这是我的错误 insert into font values('wom的ena'); ERROR 1406 (22001): Data too long for column 'a' at row 1ont values('wom的ena');我的jsp sql="insert into font values('你是who you are')"; if(st.execute(sql)) 然后从JSp页面返回可以看见中文while(rs.next()){ String content=rs.getString("a");
out.print(content+"<br>"); }你是who you are 你是who you are 然而在数据库中查询 浣犳槸who you are 浣犳槸who you are 浣犳槸who you are 这样的乱码而且我在数据库中直接插入 就会报错,什么Data too long for column 错误
这是我的错误
insert into font values('wom的ena');
ERROR 1406 (22001): Data too long for column 'a' at row 1ont values('wom的ena');我的jsp
sql="insert into font values('你是who you are')";
if(st.execute(sql))
然后从JSp页面返回可以看见中文while(rs.next()){
String content=rs.getString("a");
out.print(content+"<br>");
}你是who you are
你是who you are
然而在数据库中查询
浣犳槸who you are
浣犳槸who you are
浣犳槸who you are
这样的乱码而且我在数据库中直接插入
就会报错,什么Data too long for column 错误
通过哪个 ide 直接插入?
还是通过 sql 语句?