JDBC type for Informix TEXT column?
Posted in 2013
Laird Nelson — — source: IIUG Forums & Mailing Lists
The Informix JDBC driver, version 3.70.JC7 and earlier, when run against an Informix 11.70 server on Linux, reports that the JDBC type of a TEXT column is java.sql.Types#LONGVARCHAR. This seems OK. When we call resultSet.getObject("columName") on that column, however, it returns a byte[]. I would have expected a String. TEXT is a character data type, albeit a large object one, but still. Was there a particular rationale for this? (Is there another list where I should be asking JDBC driver questions?) Best, Laird -- http://about.me/lairdnelson --001a11c3361a86344904da2c1d56