sql7.0数据库更新中有时会出现String or binary data would be truncated错误，为什么？

rox 2001-05-23 09:18:00

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
try
{
String id=request.getParameter("id");
String section=request.getParameter("section");
String question=request.getParameter("question");
String option1=request.getParameter("option1");
String option2=request.getParameter("option2");
String option3=request.getParameter("option3");
String option4=request.getParameter("option3");
String answer=request.getParameter("answer");
String mark=request.getParameter("mark");
String difficulty=request.getParameter("difficulty");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:networks";
Connection con=DriverManager.getConnection(url,"sa","");
PreparedStatement statement=con.prepareStatement("UPDATE schoose SET section=?,question=?,option1=?,option2=?,option3=?,option4=?,answer=?,mark=?,difficulty=? where id='"+id+"'");
statement.setString(1,section);
statement.setString(2,question);
statement.setString(3,option1);
statement.setString(4,option2);
statement.setString(5,option3);
statement.setString(6,option4);
statement.setString(7,answer);
statement.setString(8,mark);
statement.setString(9,difficulty);
statement.executeUpdate();
con.close();
}
catch(Exception e)
{out.println(e);}
%>
<HTML>
<HEAD>
<TITLE> Do update </TITLE>

</HEAD>

<BODY>
<jsp:include page="/index/danxuan/manage.jsp" flush="true"/>
</BODY>
</HTML>

1、sql7.0数据库更新中有时会出现String or binary data would be truncated错误，为什么？
2、数据库的纪录每次只能读一次，为什么？
3、同一道题目在修改时不能同时修改多个选项的值，为什么？

...全文