通过Microsoft OLE DB Provider for ODBC Driver进行连接需要配置客户端ODBC,在客户端ODBC配置中有一高级选项,可以对数据类型进行配置:
长对象二进制处理:有两个选项(作为LOB数据;作为LongVar数据)
选用作为LongVar数据,并指定最大LOB列大小
错误追踪:
错误提示1:(当文章过长超过32k)COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0102N The string constant beginning with "'
One of the following:
New constraint has been added to the tab" is too long. SQLSTATE=54002
错误提示2:(当文章过长超过32k)COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0010N The string constant beginning with "'深入学习贯彻党的十六大精神进一步开创工会工作新局面
澆澆 ———在全" does not have an ending string delimiter. SQLSTATE=42603
错误提示3:(当文章中出现”和’与中文字符混合,但是位于中文字符两侧的”和‘符号有不对称时)COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token """" was found following "'','"""""''''中文俄'". Expected tokens may include: "". SQLSTATE=42601
错误提示4:(当插入AA文章时)COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0010N The string constant beginning with "'