I'm a bit curious about this. I'm using the jconnect driver( jconn3 version 6.) I have a column defined as:
datatype: 2005 type_name: TEXT Column size: 2147483647 Buffer Length: 16 On retrievals TEXT works just fine, and on updates/inserts TEXT is fine also IF the field is not null, but if the field is null, Sybase complains when it's declared as a TEXT (or CLOB) ( #spec:TEXT# ). Yet if I change it to VARCHAR the null value is accepted and the insert/update works. Shouldn't TEXT jdbc type work for all phases of the CRUD? -- Rick
