Can you post the code or sql that you are attempting to execute that is throwing tis error?
-----Original Message----- From: Oliver Chua To: [EMAIL PROTECTED] Sent: 6/28/04 5:08 AM Subject: SQLException when retrieving resultset containing mediumint (4.1.2b-alpha-win db and java-3.1.2-alpha driver) I'm using mysql-4.1.2b-alpha-win.zip and mysql-connector-java-3.1.2-alpha.zip to access db via JDBC. The column is mediumint(9) It was created using type mediumint, somehow it was changed to mdiumint(9) I think there may be a problem in the size... java.sql.SQLException: Unknown type '9 in column 0 of 3 in binary-encoded result set. at com.mysql.jdbc.MysqlIO.unpackBinaryResultSetRow(MysqlIO.java:3888) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1211) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2036) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:395) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1824) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1278) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState ment.java:1283) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta tement.java:903) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:162 2) Any ideas to correct this? Or any workarounds? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
